how to increment id value mysql code example

Example: increment id in mysql

CREATE TABLE User (id INT PRIMARY KEY AUTO_INCREMENT,email)