Tag Info

New answers tagged

1

in 5.6.12: (Well, not really an answer, but more info.) mysql> insert into se108833 (product_id,product_id_nn) values ('',''); Query OK, 1 row affected, 2 warnings (0.00 sec) mysql> show warnings; +---------+------+-----------------------------------------------------------------+ | Level | Code | Message ...


0

Well, I couldn't figure out how to do it in Mysql Workbench, but I have a workaround. Use: mysqldump -u mysqlUser -p DatabaseName TableName > table_data To get data out of the table you want to use, then use: mysql -u mysqlUser -p DatabaseName TableName < table_data To get the data into the desired table. This will retain the correct values.



Top 50 recent answers are included