创建用户并给用户授予权限
grant select,insert,update,delete on snsxiu.* to ‘snsxiu’@’192.168.%.%’ identified by ‘password’;
导出数据库结构:
mysqldump –opt -d -p job > /home/admin/job.sql
导出数据库结构包含数据:
mysqldump -uroot -p job > /home/admin/job.sql
导入SQL文件:
mysql> source /home/admin/job.sql
用B表的列xxx更新A表的列XX
mysql>update table1 as A,table2 as B set A.xx=B.xxx where A.yy=B.yyy;