Source: Reliable Penguin Blog

Reliable Penguin Blog MySQL - Run Command On All Tables

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

Read full article »
Est. Annual Revenue
$5.0-25M
Est. Employees
1-25
CEO Avatar

CEO

Update CEO

CEO Approval Rating

- -/100