mysql 查询

1、查询数据库下所有表

select * from information_schema.`TABLES` t where t.TABLE_SCHEMA ='zhaoyl_crawling'; 

或者使用

show tables;

2、mysql 字符串了连接

select concat('select count(*) from ',t.TABLE_NAME,';' ) from information_schema.`TABLES` t where t.TABLE_SCHEMA ='zhaoyl_crawling';

3、navicat for mysql 执行选择语句快捷键：ctrl+shift+r

4、多字段更新

update circle_message m,wx_user u set m.nick_name = u.nick_name,m.head_img = u.head_img where u.id = m.uid;