Execute INSERT if table is empty?

by

Use SELECT instead of VALUES to be able to expand the query with a WHERE clause.

EXISTS is a better & faster test than COUNT

INSERT INTO my_table (colname)
SELECT 'foo'
WHERE NOT EXISTS (SELECT * FROM my_table)

More Related Contents:

  1. get first occurrence of last changed value of a column [closed]
  2. MySQL – Rows to Columns
  3. ROW_NUMBER() in MySQL
  4. multiple query same table but in different columns mysql
  5. How can I make SQL case sensitive string comparison on MySQL?
  6. How can I temporarily disable a foreign key constraint in MySQL?
  7. How to do a batch insert in MySQL
  8. Count the occurrences of DISTINCT values
  9. Ordering by the order of values in a SQL IN() clause
  10. Creating a “Numbers Table” in MySQL
  11. SQL Selecting from two Tables with inner join and limit [duplicate]
  12. MySQL Group by SUM
  13. Set NOW() as Default Value for datetime datatype?
  14. In SQL, how to select the top 2 rows for each group
  15. Mysql query to dynamically convert rows to columns on the basis of two columns
  16. SQL DELETE with JOIN another table for WHERE condition
  17. mysql trigger stored trigger is already used by statement which invoked stored trigger
  18. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  19. MySQL: How do I join same table multiple times?
  20. mysql update query with sub query
  21. What is the difference between the backtick and the square bracket in SQL statements?
  22. Integrity constraint violation: 1452 Cannot add or update a child row:
  23. How to insert a file in MySQL database?
  24. What does SQL Select symbol || mean?
  25. What is wrong with my SQL here? #1089 – Incorrect prefix key
  26. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  27. How to speed up sql queries ? Indexes?
  28. What happens when I exhaust a bigint generated key? How to handle it?
  29. is there a length limit to group_concat or another reason why it would not work on a text field
  30. Deleting a row based on the max value

Leave a Comment