|
目录
8.1 插入数据
8.2 更新数据
8.3 删除数据
CREATE TABLE person
(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
name CHAR(40) NOT NULL DEFAULT '',
age INT NOT NULL DEFAULT 0,
info CHAR(50) NULL,
PRIMARY KEY (id)
);
8.1 插入数据
INSERT INTO person (id ,name, age , info) VALUES (1,'Green', 21, 'Lawyer');
INSERT INTO person (age ,name, id , info) VALUES (22, 'Suse', 2, 'dancer');
INSERT INTO person VALUES (3,'Mary', 24, 'Musician');
INSERT INTO person (name, age,info) VALUES ('Willam', 20, 'sports man');
INSERT INTO person (name, age ) VALUES ('Laura', 25);
INSERT INTO person(name, age, info) VALUES ('Evans',27, 'secretary'),
('Dale',22, 'cook'),
('Edison',28, 'singer');
INSERT INTO person VALUES (9,'Harry',21, 'magician'),
(NULL,'Harriet',19, 'pianist');
-- 拷贝一个表的数据到另外一个表
CREATE TABLE person_old
(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
name CHAR(40) NOT NULL DEFAULT '',
age INT NOT NULL DEFAULT 0,
info CHAR(50) NULL,
PRIMARY KEY (id)
);
INSERT INTO person_old VALUES (11,'Harry',20, 'student'),
(12,'Beckham',31, 'police');
INSERT INTO person(id, name, age, info) SELECT id, name, age, info FROM person_old;
8.2 更新数据
-- UPDATE
UPDATE person SET age = 15, name='LiMing' WHERE id = 11;
UPDATE person SET info='student' WHERE id BETWEEN 19 AND 22;
8.3 删除数据
DELETE FROM person WHERE id = 11;
DELETE FROM person WHERE age BETWEEN 19 AND 22;
DELETE FROM person;
-- TRUNCATE TABLE
-- 将直接删除原来的表并重新创建一个表，其语法结构为TRUNCATE TABLE table_name。
-- TRUNCATE直接删除表而不是删除记录，因此执行速度比DELETE快
| 
转播
