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)
);
ChungBlog
A wise man can learn from a foolish question, and then a fool can learn more from a wise answer.
ChungBlog 
Leave a comment