CREATE TABLE syntax in MySQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of the CREATE TABLE statement in SQL?

The CREATE TABLE statement is used to make a new table in a database where you can store data in rows and columns.

beginner

Which keyword defines the name of the table in a CREATE TABLE statement?

The table name comes right after the CREATE TABLE keywords. For example, in CREATE TABLE students, students is the table name.

beginner

How do you specify columns and their data types when creating a table?

Inside parentheses after the table name, list each column name followed by its data type, separated by commas. For example: (id INT, name VARCHAR(50)).

intermediate

What does PRIMARY KEY mean in a CREATE TABLE statement?

A PRIMARY KEY is a column (or set of columns) that uniquely identifies each row in the table. It helps keep data organized and prevents duplicates.

beginner

Write a simple CREATE TABLE statement for a table named books with columns id (integer primary key) and title (text up to 100 characters).

Example:<br>CREATE TABLE books (id INT PRIMARY KEY, title VARCHAR(100));

What keyword starts the command to create a new table in SQL?

A MAKE TABLE

B NEW TABLE

C CREATE TABLE

D ADD TABLE

The correct syntax to create a table starts with CREATE TABLE.

In the statement CREATE TABLE users (id INT, name VARCHAR(50));, what does VARCHAR(50) mean?

A A text column with max 50 characters

B A number column with max 50 digits

C A date column with 50 days

D A boolean column

VARCHAR(50) means a text column that can hold up to 50 characters.

Which of these is a valid data type for a column in MySQL?

A TEXTUAL

B INT

C NUMBERIC

D CHARACTERSTRING

INT is a valid data type for integers in MySQL.

What does the PRIMARY KEY constraint do?

A Creates a foreign key

B Allows duplicate values

C Stores large text

D Uniquely identifies each row

PRIMARY KEY ensures each row is unique and identifiable.

Which symbol is used to separate columns in a CREATE TABLE statement?

A ,

B .

C :

D ;

Columns are separated by commas , inside the parentheses.

Explain the basic structure of a CREATE TABLE statement and what each part does.

Think about how you tell the database to make a new box (table) with labeled sections (columns).

Describe why defining a PRIMARY KEY is important when creating a table.

Imagine a student ID that is unique for each student.