INSERT INTO table_listnames (name, address, tele) SELECT * FROM (SELECT 'John', 'Doe', '022') AS tmp WHERE NOT EXISTS ( SELECT name FROM table_listnames WHERE name = 'John' ) LIMIT 1;
mysql insert if condition not exist
Written By xx on Wednesday, June 12, 2013 | 7:30 PM
Related Games
If you enjoyed this article just click here, or subscribe to receive more great content just like it.
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment