Feb 27, 2001 #1 gm456 Programmer Aug 4, 2000 11 GB 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
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
Feb 27, 2001 #2 iqof188 IS-IT--Management Nov 9, 2000 228 GB 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> Upvote 0 Downvote
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>