JJ> I need to create a table that have field names 'LEFT' and
JJ> 'RIGHT'. I have tried the following but it doesn't work:
JJ> [..skip..]
JJ> But nothing works. How should I do?
Rename 'left' and 'right' to something else. They are reserved words.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> I need to create a table that have field names 'LEFT' and 'RIGHT'. I have tried the
>following but it doesn't work:
See http://www.mysql.com/doc/R/e/Reserved_words.html
Hint: use another laguage. In German, it is links and rechts for
left and richt.
--
Herzlich
Werner Stuerenburg
Hi,
I need to create a table that have field names 'LEFT' and 'RIGHT'. I have tried the
following but it doesn't work:
CREATE TABLE WI_POSITION (
PICTUREFILE VARCHAR(200) NOT NULL,
PICFILEXT VARCHAR(5),
POSITIONNOVARCHAR(10) NOT NULL,
SEQUENCENOVARCHAR(3),
LEFT
