aeroswat Posted February 2, 2010 Share Posted February 2, 2010 Am I getting this right? TRUNCATE TABLE tablename; This will re-create the table minus the data stored in it. So in this case it will also reset the record count (Meaning that if you ended at record #1000 and you perform this operation you will start at record #1) DELETE FROM tablename; This will delete the table's data. So in this case it will not reset the record count (Meaning that if you ended at record #1000 and you perform this operation you will start at record #1001) Quote Link to comment https://forums.phpfreaks.com/topic/190687-mysql-interpretation/ Share on other sites More sharing options...
aeroswat Posted February 2, 2010 Author Share Posted February 2, 2010 Anyone? I'd try this out but naturally it's probably not a good idea to just wipe out the database haphazardly Quote Link to comment https://forums.phpfreaks.com/topic/190687-mysql-interpretation/#findComment-1005620 Share on other sites More sharing options...
mikesta707 Posted February 2, 2010 Share Posted February 2, 2010 You should use a test database to test out what little nuances come along with these commands, but yes, more or less your thoughts are correct Quote Link to comment https://forums.phpfreaks.com/topic/190687-mysql-interpretation/#findComment-1005622 Share on other sites More sharing options...
aeroswat Posted February 2, 2010 Author Share Posted February 2, 2010 You should use a test database to test out what little nuances come along with these commands, but yes, more or less your thoughts are correct Thankyou. Quote Link to comment https://forums.phpfreaks.com/topic/190687-mysql-interpretation/#findComment-1005625 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.