1、處理的表

CREATE TABLE `student` ( `id` int(50) NOT NULL AUTO_INCREMENT, `name` varchar(50) DEFAULT NULL, `sex` varchar(48) DEFAULT NULL, `age` varchar(50) DEFAULT NULL, `birthday` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=244 DEFAULT CHARSET=utf8

2、查詢ID為11的資訊

SELECT * FROM student WHERE id=11

3、插入一組資料

INSERT INTO student(NAME,sex,age,birthday) VALUE("黃河濤濤h","男＇,23,1993)

DELETE FROM student WHERE student.name="李明＇

5、修改一組資料