CREATE TABLE IF NOT EXISTS users ( user_id int(10) unsigned NOT NULL AUTO_INCREMENT, name varchar(100) NOT NULL, email varchar(100) NOT NULL, PRIMARY KEY (user_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8; insert into users(name,email) values ('user1', 'user1@example.com'); insert into users(name,email) values ('user2', 'user2@example.com'); insert into users(name,email) values ('user3', 'user3@example.com');