I'm trying to import a .csv file into a table using MySQL WB. It was working fine up until I truncated a table, now I seem to have edit access via the workbench revoked. I've recreated the table from a create statement I have on backup, but the Import button is still not the. The problem seems to be there for this specific table only, all other ones are fine. Has anyone come across this before?
Ah, answered it myself ) just needed to ad primary key column
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With