Can anyone offer a reason as to why I am getting a 1064 syntax error
with this in 5.0.27?

CREATE TABLE userlogin(
username VARCHAR2(128) PRIMARY KEY,
password VARCHAR2(128) NOT NULL,
email VARCHAR2(128) NOT NULL,
phone VARCHAR2(128) NOT NULL,
company VARCHAR2(128) NOT NULL,
passwordhint VARCHAR2(128),
passwordanswer VARCHAR2(128));

Thanks,

avidFan

avidfan wrote:
> Can anyone offer a reason as to why I am getting a 1064 syntax error
> with this in 5.0.27?
>
> CREATE TABLE userlogin(
> username VARCHAR2(128) PRIMARY KEY,
> password VARCHAR2(128) NOT NULL,
> email VARCHAR2(128) NOT NULL,
> phone VARCHAR2(128) NOT NULL,
> company VARCHAR2(128) NOT NULL,
> passwordhint VARCHAR2(128),
> passwordanswer VARCHAR2(128));
>
> Thanks,
>
> avidFan
>

Password is a reserved word in MySQL.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

On Sat, 30 Dec 2006 21:41:03 -0600, avidfan <noone@nowhere.com> wrote:

>Can anyone offer a reason as to why I am getting a 1064 syntax error
>with this in 5.0.27?
>
>CREATE TABLE userlogin(
> username VARCHAR2(128) PRIMARY KEY,
> password VARCHAR2(128) NOT NULL,
> email VARCHAR2(128) NOT NULL,
> phone VARCHAR2(128) NOT NULL,
> company VARCHAR2(128) NOT NULL,
> passwordhint VARCHAR2(128),
> passwordanswer VARCHAR2(128));
>
>Thanks,
>
>avidFan

Thanks for the tips.

I was able to get it to run by changing varchar2 to varchar.

hanks,

avidFan