[clee06]

Hey guys, what is the code to delete all the records(rows) in a table? I only know the drop table 'table_name' command.

[modi123_1]

You can use 'DELETE' with no 'where' clause..
https://dev.mysql.co.../en/delete.html

or.. truncate.
https://dev.mysql.co...cate-table.html

[clee06]

So i can do something like:

DELETE FROM "table_name"

... and it will clean my table?

Nevermind I tried it and it works. Thank you!

This post has been edited by clee06: 09 October 2012 - 09:52 AM

[modi123_1]

Yup... what happens when you run it?

[clee06]

modi123_1, on 09 October 2012 - 09:51 AM, said:

Yup... what happens when you run it?

empty out my table, but my column name still exists.

This post has been edited by clee06: 09 October 2012 - 10:01 AM

[modi123_1]

Well.. yeah. That's the point - it deletes the rows. Why would you need it to delete the columns as well?

[clee06]

modi123_1, on 09 October 2012 - 10:02 AM, said:

Well.. yeah. That's the point - it deletes the rows. Why would you need it to delete the columns as well?

haha no that is all.

I was trying to empty out the table and read a new set of records in it.

[modi123_1]

Yup.. delete is fine but if you get in to giant quantities of data you may find 'truncate' works a bit faster.. but's a whole mess of data.