一、MySQL
1、表结构
表 student 具备 列 id 和 name
2、防重建表(DDL)
CREATE TABLE IF NOT EXISTS
student ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT );
3、防重插入(DML)
INSERT IGNORE INTO student ( id, name ) VALUES ( 1, 'zhangsan' );
二、Oracle
1、表结构
表 student 具备 列 id 和 name
序列 seq_student 用以产生不重复 student.id
2、防重建表(DDL)
# TODO
CREATE TABLE student (
id INT NOT NULL PRIMARY KEY,
name VARCHAR (64)
);
3、防重插入(DML)
INSERT INTO
student ( id, name )
SELECT seq_student.nextval, 'zhangsan' FROM dual
WHERE NOT EXISTS (
SELECT * FROM student WHERE name = 'zhangsan'
);