MYSQL Error if column name true or false

[Elmar Grandel]

Hello,
i just updated my mysql database from 4.0.x to 4.1 because i like to
have the possibility to create subqueries. My problem with the new
release is the following:
In my running project i have some tables with the column name True and
False.
In the old version it was possible to do a INSERT in the following
manner:

INSERT INTO
kinkedtube( observationID , expertID,TRUE, False)
VALUES ( 125,789, 0.235, 0.258);

Now with the new version 4.1. i get a MYSQL ERROR (SQL-State: 42000,
ErrorCode: 1064). I also know how to fix the problem, if i change the
statement to

INSERT INTO
kinkedtube( observationID , expertID,kinkedtube.TRUE,
kinkedtube.False)
VALUES ( 1020,1020, 0.235, 0.258);

I dont get an error and the data get inserted in my db;
But i dont want to chance my database or my java code, so how can i
tell the mysql database that it does insert the record without adding
the table name / alias to the column name. ( Oh, something else: It is
important that the tablename is written casesensetive. If you write
KINKEDTUBE.true i also get an error).
Thanks a lot for your help and advice. Have a good one ...
Elmar

[BDR]

> But i dont want to chance my database or my java code,

The way I see it, you don't have any choice.

True and False are now used by MySql as aliases... of course you know
this now...

http://www.mysql.com/doc/en/MaxDB_Reserved_Words.html

BOOLEAN was added in MySQL version 4.1.0; it is a synonym for BOOL which
is mapped to TINYINT(1). It accepts integer values in the same range as
TINYINT as well as NULL. TRUE and FALSE can be used as aliases for 1 and 0.

Elmar Grandel wrote:

Hello,
i just updated my mysql database from 4.0.x to 4.1 because i like to
have the possibility to create subqueries. My problem with the new
release is the following:
In my running project i have some tables with the column name True and
False.
In the old version it was possible to do a INSERT in the following
manner:

INSERT INTO
kinkedtube( observationID , expertID,TRUE, False)
VALUES ( 125,789, 0.235, 0.258);

Now with the new version 4.1. i get a MYSQL ERROR (SQL-State: 42000,
ErrorCode: 1064). I also know how to fix the problem, if i change the
statement to

INSERT INTO
kinkedtube( observationID , expertID,kinkedtube.TRUE,
kinkedtube.False)
VALUES ( 1020,1020, 0.235, 0.258);

I dont get an error and the data get inserted in my db;
But i dont want to chance my database or my java code, so how can i
tell the mysql database that it does insert the record without adding
the table name / alias to the column name. ( Oh, something else: It is
important that the tablename is written casesensetive. If you write
KINKEDTUBE.true i also get an error).
Thanks a lot for your help and advice. Have a good one ...
Elmar

[BDR]

> But i dont want to chance my database or my java code,

The way I see it, you don't have any choice.

True and False are now used by MySql as aliases... of course you know
this now...

http://www.mysql.com/doc/en/MaxDB_Reserved_Words.html

BOOLEAN was added in MySQL version 4.1.0; it is a synonym for BOOL which
is mapped to TINYINT(1). It accepts integer values in the same range as
TINYINT as well as NULL. TRUE and FALSE can be used as aliases for 1 and 0.

Elmar Grandel wrote:

Hello,
i just updated my mysql database from 4.0.x to 4.1 because i like to
have the possibility to create subqueries. My problem with the new
release is the following:
In my running project i have some tables with the column name True and
False.
In the old version it was possible to do a INSERT in the following
manner:

INSERT INTO
kinkedtube( observationID , expertID,TRUE, False)
VALUES ( 125,789, 0.235, 0.258);

Now with the new version 4.1. i get a MYSQL ERROR (SQL-State: 42000,
ErrorCode: 1064). I also know how to fix the problem, if i change the
statement to

INSERT INTO
kinkedtube( observationID , expertID,kinkedtube.TRUE,
kinkedtube.False)
VALUES ( 1020,1020, 0.235, 0.258);

I dont get an error and the data get inserted in my db;
But i dont want to chance my database or my java code, so how can i
tell the mysql database that it does insert the record without adding
the table name / alias to the column name. ( Oh, something else: It is
important that the tablename is written casesensetive. If you write
KINKEDTUBE.true i also get an error).
Thanks a lot for your help and advice. Have a good one ...
Elmar