how to increment id value mysql in procedure code example

Example: increment id in mysql

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