Collections:
CREATE TABLE Statement in MySQL
How To Create a New Table in MySQL?
✍: FYIcenter.com
If you want to create a new table, you can use the "CREATE TABLE" statement. The following tutorial script shows you how to create a table called "tip":
mysql> CREATE TABLE tip (id INTEGER PRIMARY KEY, subject VARCHAR(80) NOT NULL, description VARCHAR(256) NOT NULL, create_date DATE NULL); Query OK, 0 rows affected (0.08 sec)
This scripts creates a testing table called "tip" with 4 columns in the current database.
⇒ CREATE Command Denied Error in MySQL
⇐ What Are DDL Statements in MySQL
2018-03-10, 1920🔥, 0💬
Popular Posts:
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...