shiki_41的博客

select testcode,testvalue,procode,provalue,testresult from (select test.PARAM_NAME testcode, test.result testresult, test.PARAM_VALUE testvalue,pro.param_name procode,pro.param_value provaluefrom `mia...

select column_name,column_comment from information_schema.columns where table_name = '表名';

1.找到my.ini配置文件my.ini配置文件默认在该路径下：C:\ProgramData\MySQL\MySQL Server 5.7在my.ini配置文件末尾加上skip-grant-tables，点击保存并关闭2.重启MySQL服务器cmd命令重启服务器，查看服务名为MySQL573.在MySQL\bin目录下执行命令我的默认路径：C:\Program Fi...