MySQL CREATE TABLE
The MySQL CREATE TABLE command is used to create a new table into the database. A table creation command requires three things:
- Name of the table
- Names of fields
- Definitions for each field
- CREATE TABLE table_name (column_name column_type…);
Here, we will create a table named “cus_tbl” in the database “customers”.
- Here, NOT NULL is a field attribute and it is used because we don’t want this field to be NULL. If you will try to create a record with NULL value, then MySQL will raise an error.
- The field attribute AUTO_INCREMENT specifies MySQL to go ahead and add the next available number to the id field.PRIMARY KEY is used to define a column as primary key. You can use multiple columns separated by comma to define a primary key.
Visual representation of creating a MySQL table:
See the created table:
Use the following command to see the table already created:
For any query or issue, feel free to discuss on http://discuss.eduguru.in