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, 1211👍, 0💬
Popular Posts:
What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard ...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How To See Which Storage Engines Are Supported in Your MySQL Server in MySQL? If you want to know ex...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...