Problem with Syntax?

[Styles2304]

Here's the code I ran to setup my DB table: BonusInfo

 

CREATE TABLE `black_arku`.`BonusInfo` (`IndexNo` SMALLINT NOT NULL ,`Bonus` TEXT NOT NULL ,`History` TEXT NOT NULL ,INDEX ( `IndexNo` ));

 

And then here is the insert statement I'm trying to execute but I'm getting a syntax error:

 

INSERT INTO `black_arku` . `BonusInfo` VALUES (1, '0', '0');

 

Is there something I'm missing?

[Rodis]

try this.

INSERT INTO Name_of_the_table (black_arku , BonusInfo) VALUES ('1','0');

 

i removed one 0 because i don't understand if 2 fields are given why u are trying to insert 3 sets of data. The 1 corresponds to the field black_arku and the 0 to Bonusinfo in this example.

[Styles2304]

. . . No. `black_arku` is the database reference `BonusInfo` is the table. If you notice in the create, there are 3 fields: IndexNo, Bonus, and History. Anyone else have any ideas?

[Rodis]

OK

INSERT INTO Bonusinfo (IndexNo, Bonus, History) VALUES ('1','0','0');

 

This is the way  your query should look.

 

INSERT INTO Tablename (Fieldname, Fieldname, Fieldname) VALUES ('value','Value','Value');

 

Connection to the database should be made earlier.

 

 

 

 

[Mchl]

What is the error you get?

[corbin]

OK

INSERT INTO Bonusinfo (IndexNo, Bonus, History) VALUES ('1','0','0');

 

This is the way  your query should look.

 

INSERT INTO Tablename (Fieldname, Fieldname, Fieldname) VALUES ('value','Value','Value');

 

Connection to the database should be made earlier.

 

 

 

 

 

 

It is perfectly valid, acceptable and even semi-common to not select a database.

 

 

The full name of a table can be used in a statement.

 

 

INSERT INTO database.table.....