Bickey Posted February 1, 2011 Share Posted February 1, 2011 What is the syntaxt which is used to delete all records from a database? Thanks. Bickey. Quote Link to comment Share on other sites More sharing options...
mikosiko Posted February 1, 2011 Share Posted February 1, 2011 not clear if you want to: - delete all the records from one table or - delete the database completely with all that it contains I hope you understand the difference between table and database Quote Link to comment Share on other sites More sharing options...
ttocskcaj Posted February 2, 2011 Share Posted February 2, 2011 If you want to delete every row from a table, but keep the table: DELETE FROM `table_name` If you want to delete the whole table DROP TABLE `table_name` If you want to delete the whole database DROP DATABASE `database_name` It might be best if you use a front end like PHPMyAdmin. Then you can visualize exactly what you're deleting, And BACKUP 1st Good Luck Quote Link to comment Share on other sites More sharing options...
The Little Guy Posted February 2, 2011 Share Posted February 2, 2011 this will reset everything in your table: TRUNCATE my_table Quote Link to comment 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.