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, 1408🔥, 0💬
Popular Posts:
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...