table is being created, data not being inputted, can someone tell me why?

[Matt Ridge]

CREATE TABLE `comp` (

  `comp_id` INT AUTO_INCREMENT,

  `name` VARCHAR(60),

  PRIMARY KEY (`comp_id`)

);

 

INSERT INTO `comp` VALUES (1, `Charles River Labs`);

INSERT INTO `comp` VALUES (2, `Dakota Systems, Inc.`);

INSERT INTO `comp` VALUES (3, `Nexx Systems, Inc.`);

INSERT INTO `comp` VALUES (4, `3M Touch Systems`);

 

 

I get an error on the first insert into line... #1054 - Unknown column 'Charles River Labs' in 'field list'

 

Which means: Message: Unknown column '%s' in '%s'

 

I don't understand why though...

 

Can someone tell me what I am missing?

[Pikachu2000]

Backticks are for db/table/field names.

[Matt Ridge]

Backticks are for db/table/field names.

 

So it should be INSERT INTO `comp` VALUES (1, 'Charles River Labs');

 

?

[Pikachu2000]

Yes. And there's really no reason to provide a value for an autoincrement field. Also, this could be done in one query rather than multiple queries.

 

INSERT INTO `comp` ( name ) VALUES ( 'Charles River Labs' ), ( 'Dakota Systems, Inc.'), ( 'Nexx Systems, Inc.' ), ( '3M Touch Systems' );

[Matt Ridge]

Yes. And there's really no reason to provide a value for an autoincrement field. Also, this could be done in one query rather than multiple queries.

 

INSERT INTO `comp` ( name ) VALUES ( 'Charles River Labs' ), ( 'Dakota Systems, Inc.'), ( 'Nexx Systems, Inc.' ), ( '3M Touch Systems' );

 

I keep forgetting that myself...