mysqlTruncate all tables in a specific database
mysql db -Nse 'show tables' | while read table; do mysql db -e "truncate table $table"; donectrl + cmysql db -Nse 'show tables'prints all tables from | while read tableexecute loop for each table (each line) printed |
mysql db -e "truncate table $table"execute truncate query for each | |
More of Mysql
- Insert/update multiple rows in single query
- How to find my.cnf config file
- Disable ONLY_FULL_GROUP_BY mode
- Get largest tables list
- What is the MEDIUMTEXT column max size (length) in Mysql
- What is the TINYINT column max value and size in Mysql
- How to find duplicate varchar/text column values in table
- Make a pager (limit / offset) select query
- What is the LONGTEXT column max size (length) in Mysql
See more codes...