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) 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 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 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. Link to comment https://forums.phpfreaks.com/topic/190687-mysql-interpretation/#findComment-1005625 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.