Deleteing all rows in CF/Linux MySQL

[gm456]

Bad hair day... whats the syntax to remove all records from a table (I was using delete * from tblname on the NT box but it doesn't work with MySQL)

TIA

GM

 

[iqof188]

I don't know MySQL that well (to tell you the truth I never used it at all ), but for every DB-system I've worked with it is:

DELETE FROM tablename

For you it's just a matter of getting rid of the asterisk (*). Good luck!

<webguru>iqof188</webguru>