Hi All,

I tried to execute this code and error pops up. I need to create a table field name REQUIRE however REQUIRE is a reserve command for mySQL. Anyone know how to deal with this?

CREATE TABLE TB_RFP_REQUIRE (
RFP_ID int(10) unsigned default NULL,
RFP_REQUIRE_ID int(10) unsigned default NULL,
REQUIRE varchar(80) default NULL
) TYPE=MyISAM;

Thanx in advance!

Regards,
Mar

Use another name. You can not name a variable "int" in C, "function" in PHP or "for" in Ada and you can not call a column "REQUIRE" in SQL. You need to call it something else. Reserved words are reserved, and there is no way around it. Why can't you just use another name?

just use backticks, e.g. `REQUIRE`