# our table CREATE TABLE example ( id int unsigned not null primary key auto_increment, num int, str varchar(50) ); # our insert statement insert into example (num,str) values(5,"hello"); # test and see what we get select * from example; +----+------+-------+ | id | num | str | +----+------+-------+ | 1 | 5 | hello | +----+------+-------+ 1 row in set (0.00 sec)