創建一個student表用于存儲學生信息
CREATE TABLE student( id INT PRIMARY KEY, name VARCHAR(20) NOT NULL, grade FLOAT );
向student表中添加一條新記錄 記錄中id字段的值為1，name字段的值為"monkey"，grade字段的值為98.5
insert into student (id,name,grade) values('1','monkey','98.5');
向student表中添加多條新記錄 2,"bob",95.5 3,"john",90.0 4,"smith",88.5
insert into student (id,name,grade) values('2','bob','95.5'),('3','john','90.0'),('4','smith','88.5');
向student表中添加一條新記錄，部分數據插入 5,"jone"
insert into student (id,name) values('5','jone');
更新表，grade 大于90的加0.5
update student
set grade = grade + 0.5
where grade > 90;
刪除成績為空的記錄
delete from student
where grade is null;
用戶權限
創建一個用戶test1使他只能本地登錄擁有查詢student表的權限
reate user test1@'localhost' identified by '123';
grant select on db_system.* to test1@'localhost' ;
查詢用戶test1的權限
show grants for test1@localhost;
刪除用戶test1
drop user test1@'localhost';
)
