Here's a one-liner to run a SQL command on all tables in a database: [crayon-5e0cc20f8109c641368898/] Replace "show create table" with the command that you wish to execute. Replace "mydb" with your database name. Replace "root" and "mypassword" with you username and password. Replace "localhost" with your database server hostname or IP address. Reliable Penguin - Blog