The following statement creates a table named employees that has the emp_no column is an AUTO_INCREMENT column:

 CREATE TABLE employees (    
emp_no INT AUTO_INCREMENT PRIMARY KEY,    
first_name VARCHAR(50),    
last_name VARCHAR(50)
);