MySQL Create Table
Learn all about MySQL Create Table in this comprehensive tutorial.
- •To create a table in MySQL, use the "CREATE TABLE" statement.
- •You can check if a table exist by listing all tables in your database with the "SHOW TABLES" statement:
- •When creating a table, you should also create a column with a unique key for each record.
Creating a Table
To create a table in MySQL, use the "CREATE TABLE" statement.
Make sure you define the name of the database when you create the connection
If the above code was executed with no errors, you have now successfully created a table.
Check if Table Exists
You can check if a table exist by listing all tables in your database with the "SHOW TABLES" statement:
Primary Key
When creating a table, you should also create a column with a unique key for each record.
This can be done by defining a PRIMARY KEY.
We use the statement "INT AUTO_INCREMENT PRIMARY KEY" which will insert a unique number for each record. Starting at 1, and increased by one for each record.
If the table already exists, use the ALTER TABLE keyword:
Module quiz
Test your knowledge on this module