R
Railway15mo ago
sebwro

How to save a bit in MySQL database?

I am trying to put data in my table in SQL, but whenever I come across bit, the table does not accept 0 / 1 as input (the error says "data too long"). What should I put then?
No description
9 Replies
Percy
Percy15mo ago
Project ID: ddf68b83-2f55-42da-999f-aab89be499cc
sebwro
sebwroOP15mo ago
ddf68b83-2f55-42da-999f-aab89be499cc
Brody
Brody15mo ago
please don't use that, use a proper database management tool like mysql workbench
sebwro
sebwroOP15mo ago
What do you mean? I deployed my application here and it uses SQL database. I exported tables from workbench here, but I need to insert the data as well
Brody
Brody15mo ago
yes you should use mysql workbench for these tasks
sebwro
sebwroOP15mo ago
I have data in my tables In workbench, how to I copy the data from workbench here then? when I exported, it only exported the tables without the data
Brody
Brody15mo ago
you would want to connect to the railway database from mysql workbench
sebwro
sebwroOP15mo ago
oh, thanks. Is there tutorial how to do that>
Brody
Brody15mo ago
mysql workbench has documentation https://www.mysql.com/products/workbench/
Want results from more Discord servers?
Add your server