How to delete all rows in all table of a database in mysql -
i had database 500 tables , want delete records of tables. how achieve this. experts please help...
the simplest way drop , recreate database structure using these shell commands:
mysqldump -d dbname > structure.sql mysqladmin drop dbname mysqladmin create dbname mysql dbname < structure.sql
insert mysql credentials required, eg -u root -psecret -h localhost
Comments
Post a Comment