艺海无涯,学无止境。欢迎一起探讨研究技术。

MySql

MySql

Mysql递归查询所有子项

   WITH RECURSIVE result(id, routename ,routeurl,typeid ,parentid) AS (SELECT id, routename ,routeurl,typeid ,parentid FROM auth_route WHERE id = 1 UNION ALL SELECT i.id, i.routena...

MySql

Mysql修改字符集的方法

   修改字符集的方法,就是使用mysql的命令 mysql> SET character_set_client = utf8 ; mysql> SET character_set_connection = utf8 ; mysql> SET character_set_database = utf8 ; mysql> SET ch...