MYSQL命令集

MySql将一个表的数据复制到另外一张表

INSERT INTO productinfo SELECT * FROM  backproduct where id=7167

 

删除字段中的空格：update apply set enname=replace(`enname`,' ','');

查询name大于7位数的字段： length(name) > 7

统计用户购买次数和购买总金额： SELECT uid,SUM(totalprice) as total, count(uid) as nameid FROM `orders` GROUP BY uid;