dump 表，包含四个字段 id, name, phone, status
INSERT INTO dump(id, name, phone, status)
SELECT 1, "test", "111", 2
FROM dump where not exists (select * from dump where name = "test" and status = 2)limit 1
请问上面这个语句正确么？如果正确，是如何执行的。
› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
This topic created in 2751 days ago, the information mentioned may be changed or developed.
No Comments Yet
Select Language