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, 1406🔥, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...