Primary key declaration in MySQL - Step-by-Step Execution

Concept Flow - Primary key declaration

Start table creation

↓

Define columns

↓

Declare primary key on column(s)

↓

Primary key enforces uniqueness

↓

Table ready for data insertion

When creating a table, you define columns and then declare one or more columns as the primary key, which ensures each row is unique.

Execution Sample

MySQL

CREATE TABLE users (
  id INT,
  name VARCHAR(50),
  PRIMARY KEY (id)
);

This code creates a table named 'users' with 'id' as the primary key, ensuring 'id' values are unique.

Execution Table

Step	Action	Evaluation	Result
1	Start table creation	Table 'users' does not exist	Table creation process begins
2	Define column 'id' as INT	Column 'id' added	Column 'id' ready
3	Define column 'name' as VARCHAR(50)	Column 'name' added	Column 'name' ready
4	Declare PRIMARY KEY on 'id'	Check uniqueness and NOT NULL constraint	Primary key set on 'id'
5	Finish table creation	Table structure valid	Table 'users' created with primary key

💡 Table creation ends after primary key declaration ensures uniqueness

Variable Tracker

Variable	Start	After Step 2	After Step 3	After Step 4	Final
Table 'users'	Does not exist	Exists with column 'id'	Exists with columns 'id', 'name'	Primary key on 'id' declared	Ready for data insertion
Primary Key	None	None	None	Declared on 'id'	Declared on 'id'

Key Moments - 2 Insights

Why must a primary key column be unique and not null?

Because the primary key uniquely identifies each row, it cannot have duplicates or missing values. This is shown in execution_table step 4 where uniqueness and NOT NULL are enforced.

Can a table have more than one primary key?

No, a table can have only one primary key, but it can be made of multiple columns (composite key). This is implied in the declaration step 4 where one primary key is set.

Visual Quiz - 3 Questions

Look at the execution_table, at which step is the primary key declared?

A Step 4

B Step 2

C Step 3

D Step 5

💡 Hint

Check the 'Action' column for primary key declaration in execution_table row 4

According to variable_tracker, what is the state of the table after step 3?

A Table does not exist

B Table exists with columns 'id' and 'name', no primary key

C Primary key declared on 'id'

D Table ready for data insertion

💡 Hint

Look at 'Table users' row and 'After Step 3' column in variable_tracker

What does the primary key enforce according to the concept_flow?

A Allows null values in key column

B Allows duplicate rows

C Ensures uniqueness of rows

D Deletes duplicate rows automatically

💡 Hint

Refer to the last box in concept_flow about primary key enforcing uniqueness

Concept Snapshot

Primary key declaration syntax:
PRIMARY KEY (column_name)
- Declares one or more columns as unique identifiers
- Ensures no duplicate or null values in key columns
- Only one primary key per table allowed
- Must be declared during or after column definitions

Full Transcript

When creating a table in MySQL, you define columns first. Then you declare a primary key on one or more columns. The primary key ensures each row is unique and the key columns cannot be null. This is important because it helps identify each row clearly. The execution steps show starting the table creation, adding columns, declaring the primary key, and finishing the table. The variable tracker shows how the table and primary key state change after each step. Common confusions include why the primary key must be unique and not null, and that only one primary key is allowed per table. The quiz questions help reinforce these points by referencing the execution steps and variable states.