insert record

[filipel]

i have this table with auto increment id

DROP TABLE IF EXISTS `junta`.`subdominios`;
CREATE TABLE `junta`.`subdominios` (
`id` int(10) unsigned NOT NULL auto_increment,
`nome` varchar(45) NOT NULL default '',
`descricao` varchar(45) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

if it is an auto-increment id.How to insert a record without specifying it?

 

[r937]

INSERT 
  INTO junta.subdominios 
     ( nome , descricao )
VALUES 
     ( 'Todd' , 'Neighbour' )
   , ( 'Biff' , 'Tennis pro' )
   , ( 'Fred' , 'Milkman' )

r937.com | rudy.ca

 

[filipel]

thanks.Afterall i had been deceptive was in the table name