登錄本地:
mysql -u root -p 密碼
遠程登陸:
mysql -h IP 地址 -u 用戶名 -p 密碼
例如:mysql -h 127.0.0.1 -u root -p 密碼
use 某數(shù)據(jù)庫
增: insert into student (s_id, s_name, s_age, s_sex) values
('01' , '趙雷' , '1990-01-01' , '男'), ('02' , '錢電' , '1990-12-21' , '男'), ('03' , '孫風(fēng)' , '1990-05-20' , '男');
刪:delete from student where id=2;
查:select s_name from student;
改:update school set email='123123@qq.com' where id=2;