CREATE TABLE `temp` ( `id` int(11) NOT NULL auto_increment, `mleft` int(11) default NULL, `mright` int(11) default NULL, `access` int(11) default NULL, PRIMARY KEY (`id`) ); insert into temp (mleft, mright,access) values (1, 20,0), (2,15,0), (3,8,1), (4,5,0), (6,7,1), (9,14,0), (10,11,0), (12,13,1), (16,19,1), (17,18,1);