mysql安装与使用

转载：https://www.cnblogs.com/sfencs-hcy/p/9769505.html

修改密码：set pasword for root@localhost = password('123');

开启服务   net start mysql

进入mysql   mysql -u root -p

show databases;

use database;

show tables;

select count(*) from table; //行数

select column_name from information_schema.COLUMNS where table_name = 'atp应用';  //显示列名

退出 exit;

net stop mysql