V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member Sign In
› 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 2740 days ago, the information mentioned may be changed or developed.
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
请问上面这个语句正确么？如果正确，是如何执行的。
No Comments Yet
Select Language