Query delete all rows

10 posts
[expired user #8537]'s profile image [expired user #8537] posted 9 years ago in General Permalink
Hi, how can I delete all the rows in a table with the command query?
10 posts
[expired user #8537]'s profile image [expired user #8537] posted 9 years ago Permalink

Hi, how can I delete all the rows in a table with the command query?


If you use the button "delete selected rows" takes a long time to eliminate many lines! I tried a command faster to eliminate all without deleting the table.
10151 posts
ansgar's profile image ansgar posted 9 years ago Permalink
You can rightclick a table, then click "Empty table(s)", or press Shift+Del. This fires a 
TRUNCATE mytable;
or 
DELETE FROM mytable;
, depending on your server version.

Please login to leave a reply, or register at first.