wodecc_u的博客

创建数据库时设置uft8格式mysql> create database if not exists dbname default charset utf8 collate utf8_general_ci;查看数据库的编码mysql> use dbname;mysql> show variables like 'character_set_database';修改数据库的编码mysql> alte

mysql group by 并查出前面几条select a.*,b.name as bname from sk_product a left join sk_product_category b on a.category_id = b.id where 6 > ( select count(*) from sk_product and orde...

mysql 树形查询函数BEGINDECLARE res VARCHAR(1000);DECLARE child VARCHAR(1000);SET res='$';SET child=id;while child IS NOT NULL DOset res=CONCAT(res,',',child);SELECT GROUP_CONCAT(jgdm) into child FRO...