0

I have quite some databases built. I want to empty them without changing their structure. Is there a way to do it? if so, can you please guide me how to do that?

Matt S
  • 14,976
  • 6
  • 57
  • 76
  • you do know you can't truncate databases but only tables – Raymond Nijland Feb 06 '18 at 17:34
  • 1
    A) Find list of table names. B) Truncate them. You can do this with a text editor. – tadman Feb 06 '18 at 17:34
  • 2
    Possible duplicate of [Truncate all tables in a MySQL database in one command?](https://stackoverflow.com/questions/1912813/truncate-all-tables-in-a-mysql-database-in-one-command) – 4givN Feb 06 '18 at 17:40

0 Answers0