MySQL create table if not exists and insert record only if table was created

Combine the creation and insert into a single statement:

CREATE TABLE IF NOT EXISTS tableName (
    id int(9) NOT NULL, 
    col1 int(9) DEFAULT NULL, 
    col2 int(3) unsigned zerofill DEFAULT NULL,
    PRIMARY KEY(id)
)  ENGINE = InnoDB DEFAULT CHARSET = latin1
AS SELECT 1 AS id, 10 AS col1, 5 AS col2;

If it doesn’t create the table, AS SELECT ... clause is ignored.

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. Unknown column in ‘field list’ error on MySQL Update query
  3. Unknown column in ‘field list’ error on MySQL Update query
  4. MySQL – Operand should contain 1 column(s)
  5. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  6. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  7. How do I use properly CASE..WHEN in MySQL
  8. How can I do a FULL OUTER JOIN in MySQL?
  9. MySQL query String contains
  10. What’s the difference between VARCHAR and CHAR?
  11. Case statement in MySQL
  12. How to declare a variable in MySQL?
  13. MySQL Cannot Add Foreign Key Constraint
  14. How to split the name string in mysql?
  15. How do I import an SQL file using the command line in MySQL?
  16. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  17. mysql Foreign key constraint is incorrectly formed error
  18. MySQL: Invalid use of group function
  19. How can I return pivot table output in MySQL?
  20. Compare dates in MySQL
  21. MySQL “WITH” clause
  22. MySQL Multiple Joins in one query?
  23. Error Code: 2013. Lost connection to MySQL server during query
  24. MySQL syntax for Join Update
  25. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  26. how to drop partition without dropping data in MySQL?
  27. MySQL combine two columns into one column
  28. Simple way to calculate median with MySQL
  29. Error 1046 No database Selected, how to resolve?
  30. MySQL Error 1264: out of range value for column
  31. Remove duplicate rows in MySQL
  32. How to SUM and SUBTRACT using SQL?
  33. Cast from VARCHAR to INT – MySQL
  34. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  35. How do you force mysql LIKE to be case sensitive?
  36. MySQL – UPDATE multiple rows with different values in one query
  37. How to create a MySQL hierarchical recursive query?
  38. ERROR 1148: The used command is not allowed with this MySQL version
  39. Insert into a MySQL table or update if exists
  40. How to round down to nearest integer in MySQL?
  41. MySQL starts with searching issue
  42. Query to convert from datetime to date mysql
  43. Is it possible to GROUP BY multiple columns using MySQL?
  44. MySQL error: key specification without a key length
  45. Best way to test if a row exists in a MySQL table
  46. Check if MySQL table exists without using “select from” syntax?
  47. MySQL equivalent of DECODE function in Oracle
  48. mysql update column with value from another table
  49. The used SELECT statements have a different number of columns
  50. PostgreSQL create table if not exists
  51. How to delete from multiple tables in MySQL?
  52. MySQL: Can’t create table (errno: 150)
  53. How to copy a row and insert in same table with a autoincrement field in MySQL?
  54. Join vs. sub-query
  55. Alternative to except in MySQL
  56. Equivalent of explode() to work with strings in MySQL
  57. ROW_NUMBER() in MySQ
  58. MySQL OPTIMIZE all tables?
  59. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  60. MySQL – Get row number on select
  61. MySQL error: Unknown column in ‘where clause’
  62. How to truncate the text returned for a column in a MySQL query
  63. Using union and order by clause in mysql
  64. MySQL LIKE IN()?
  65. Case in Select Statement
  66. Self Join to get employee manager name
  67. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  68. Why does NULL = NULL evaluate to false in SQL server
  69. ORA-00918: column ambiguously defined in SELECT *
  70. How to parse XML data in SQL server table
  71. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  72. Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 4 (Year)
  73. SQL selecting rows by most recent date with two unique columns
  74. Oracle: If Table Exists
  75. How to calculate age (in years) based on Date of Birth and getDate()
  76. How to create id with AUTO_INCREMENT on Oracle?
  77. Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot
  78. How can I group by date time column without taking time into consideration
  79. Update query using Subquery in Sql Server
  80. “This SqlTransaction has completed; it is no longer usable.”… configuration error?
  81. How to execute mulitple statement SQL queries using $wpdb->query?
  82. Return number of items in a table with post id
  83. How do I find which articles are missing a featured image in The WordPress database?
  84. Debugging WordPress
  85. Importing Geo data into wordpress database
  86. Pull data and display as rows and columns
  87. Speeding SQL queries for a large database?
  88. I need a SQL command to delete specific authors and all posts connected with them
  89. How to get INSERT errors from $wpdb?
  90. How can i restore only Blogs from a SQL backup file?
  91. Sql query does not work well
  92. How to change post published date to today date with SQL
  93. Do I need to sanitize $_POST[‘keyword’] before send to ‘s’ parameter?
  94. Display a number value from mysql query in WP
  95. how to SELECT meta values that are not null?
  96. Conditional statement within WP SQL query
  97. Sql query returns empty. But not
  98. SQL – JOIN last child
  99. Delete posts with word count less than x number of words
  100. Possible SQL injection. How to locate and fix?

Leave a Comment