查询 id = 6 的所有父级SELECT ID.level, DATA.* FROM( SELECT @id as _id, ( SELECT @id := parent_id FROM table1 WHERE id = @id ) as _pid, @l := @l

错误原因 注册表问题 cmd 输入regedit 打开注册表修改默认的mysqld执行路径 修改为指定的bin文件里面的mysqld 

常用的语句查询 select * from bbs where id=1;增加 insert into bbs (name,data_year) VALUES (13"jack","1993-10-01");修改 update bbs set name="tom",sex=1,age=18 where

Select 'SET FOREIGN_KEY_CHECKS = 0;'unionSelect CONCAT( 'drop table ', table_name, ';' )FROM information_schema.tablesWhere table_name LIKE 'as_baiqis