登录本地:
mysql -u root -p 密码
远程登陆:
mysql -h IP 地址 -u 用户名 -p 密码
例如:mysql -h 127.0.0.1 -u root -p 密码
use 某数据库
增: insert into student (s_id, s_name, s_age, s_sex) values
('01' , '赵雷' , '1990-01-01' , '男'), ('02' , '钱电' , '1990-12-21' , '男'), ('03' , '孙风' , '1990-05-20' , '男');
删:delete from student where id=2;
查:select s_name from student;
改:update school set email='123123@qq.com' where id=2;