三 312009

MYSQL中如何删除多个名字相似的表

MySQL Add comments

.转载的：
#!/bin/sh

MYSQLBIN="/usr/local/mysql/bin/mysql"

$MYSQLBIN -uroot -pxxx dbname -s -e "show tables like 'NTSWKDVL_%';" \
|sed 's/^/drop table /g' |sed 's/$/;/g' >/tmp/deletetable.sql

$MYSQLBIN -uroot -p123456 wordpress -s -e </tmp/deletetable.sql

$MYSQLBIN -uroot -p123456 wordpress -s -e </tmp/deletetable.sql
新版本中可能不需要-e参数

Posted by admin Tagged with: ,