这条SQL:
SELECT column_name from information_schema.columns WHERE column_name LIKE ’%searchTerm%’ AND table_schema = ‘yourDB’ AND table_name = ‘yourDBTable’
相信大家都懂了。
导出:
/works/mysql-5.0.37/bin/mysqldump -u哈哈 -p哈哈 -hlocalhost -S /data/mysql-db/mysql.sock --default-character-set=utf8 --add-drop-database --add-drop-table --complete-insert --create-options --disable-keys --comments --quick --max_allowed_packet=16M --extended-insert --default-character-set=utf8 --database igo3 > /data/resin-vhost/1.sql
导入:
mysql -uroot -p --default-character-set=utf8 igo3 < D:\common\igo\igo.renren.com.20120331.sql