https://sqlines.com/ 2026-04-29T13:24:48+00:00 https://sqlines.com/ https://sqlines.com/lib/images/favicon.ico text/html 2011-12-15T08:05:11+00:00 https://sqlines.com/mysql/statements/create_table?rev=1323936311&do=diff CREATE TABLE statement creates a table in a MySQL database. Syntax (full...) CREATE [TEMPORARY] TABLE [IF NOT EXISTS] table_name (columns) options CREATE TABLE table_name select_statement CREATE TABLE table_name LIKE table_name2 Quick Example CREATE TABLE t (c CHAR); Table Name table_name or database_name.table_name to create the table in the specified database Temporary Table Visible only to the current connection, and dropped automatically when it is closed Versions: MySQL 5.x text/html 2011-12-22T12:30:47+00:00 https://sqlines.com/mysql/statements/insert?rev=1324557047&do=diff INSERT statement inserts one or more rows into an existing table. You can specify values explicitly, or select from another table. Quick Example: -- Create a table CREATE TABLE states (abbr CHAR(2), name VARCHAR(30)); -- Insert 3 rows INSERT INTO states VALUES ('CA', 'California'), ('TX', 'Texas'), ('WA', 'Washington');