mysql字段唯一性

-- 创建表并添加单列唯一性约束
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL UNIQUE,
    email VARCHAR(100) NOT NULL UNIQUE
);

-- 创建表并添加多列唯一性约束
CREATE TABLE orders (
    order_id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    order_number VARCHAR(50) NOT NULL,
    UNIQUE (user_id, order_number)
);

-- 检查是否已经存在相同的数据
SELECT * FROM users WHERE username = 'existing_user';

-- 如果不存在，则插入数据
INSERT INTO users (username, email) VALUES ('new_user', 'new_user@example.com');

-- 删除单列唯一性约束
ALTER TABLE users DROP INDEX username;

-- 删除多列唯一性约束
ALTER TABLE orders DROP INDEX user_id_order_number;