How can I delete a table with Komodo MySQL plugin?

Question

I've setup a Komodo remote database server with a MySQL plugin loaded and I want to empty a table. I select the table and change to the "query" tab in the MySQL plugin, but when I run "truncate table;" it does nothing. I've allowed deletion of the "full table", but I cannot delete all selected rows in the "full table" either. It gives me a KeyError: 150 or KeyError: 84?

score 0 · Accepted Answer · edited May 23 '17 at 11:48

0

Use DELETE or remove any foreign key constraints or checks before attempting to TRUNCATE.

edited May 23 '17 at 11:48

Community

1
1

answered Jul 28 '12 at 13:27

Paul Sweatte

23,524
7
119
253

How can I delete a table with Komodo MySQL plugin?

1 Answers1