SQL 插入语句(INSERT)用于向数据库表中添加新记录。以下是当前最新的 SQL 插入语句使用方法和最佳实践。
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);
INSERT INTO customers (customer_id, name, email, phone)
VALUES (1, '张三', 'zhangsan@example.com', '13800138000');
INSERT INTO customers (name, email)
VALUES ('李四', 'lisi@example.com');
INSERT INTO products (product_name, price, stock)
VALUES
('笔记本电脑', 5999.99, 100),
('智能手机', 3999.99, 200),
('平板电脑', 2999.99, 150);
INSERT INTO high_value_customers (customer_id, name, total_spent)
SELECT customer_id, name, total_purchases
FROM customers
WHERE total_purchases > 10000;
INSERT INTO orders (order_id, customer_id, order_date, status)
VALUES (1001, 123, CURRENT_DATE, DEFAULT);
INSERT INTO employees (name, department, salary)
VALUES ('王五', 'IT', 8000)
RETURNING employee_id, name;
INSERT INTO users (user_id, username, login_count)
VALUES (101, 'user101', 1)
ON DUPLICATE KEY UPDATE login_count = login_count + 1;
MERGE INTO inventory t
USING (SELECT 1 AS product_id, 100 AS quantity FROM dual) s
ON (t.product_id = s.product_id)
WHEN MATCHED THEN
UPDATE SET t.quantity = t.quantity + s.quantity
WHEN NOT MATCHED THEN
INSERT (product_id, quantity) VALUES (s.product_id, s.quantity);
-- 忽略重复键错误
INSERT IGNORE INTO table_name ...;
-- 替换已有记录
REPLACE INTO table_name ...;
-- 输出插入的ID
INSERT INTO table_name (columns)
OUTPUT INSERTED.id
VALUES (values);
-- 使用序列
INSERT INTO table_name (id, name)
VALUES (seq_name.NEXTVAL, 'Oracle用户');
希望这个最新教程对您有所帮助!如需更详细的信息,请参考您使用的特定数据库系统的官方文档。