1.官网下载mysql免安装版数据库 https://dev.mysql.com/downloads/mysql/2.解压数据库放到指定的盘符 3.创建ini文件 建议创建 里面的设置信息可以自行设置（可以去百度搜索一下）4.设置mysql的环境记得指定要对应的bin方便cmd的时候执行5

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

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

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