数据操作,DML,DataManagementLanguage详解教程.docxVIP

数据操作，DML，Data Management Language详解 一：增加操作 insert into 1：一条 insert into 可以插入多条记录 create table insert_student ( id int unsigned primary key auto_increment, stu_name varchar(20) not null default , gender enum(male,female,secret), class_id int unsigned ) engine=innodb; insert into insert_student values (11,张无忌,male,23), (34,郭襄,female,23), (44,杨过,male,34), (45,杨康,male,23); 2：insert into 支持判断主键（唯一）是否冲突，从而执行更新 insert into insert_student values (44,小龙女,female,23); 如果有冲突则可以执行下列语句： insert into 表名 (字段列表) values (值列表) on duplicate key update 字段=值,字段=值; 示例： insert into insert_student values (44,小龙女,femal