Professional Web Applications Themes

ERROR 1064 in mySQL 5.0.27 - MySQL

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...

  1. #1

    Default ERROR 1064 in mySQL 5.0.27

    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 Guest

  2. #2

    Default Re: ERROR 1064 in mySQL 5.0.27

    avidfan wrote: 

    Password is a reserved word in MySQL.

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

  3. #3

    Default Re: ERROR 1064 in mySQL 5.0.27

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

    Thanks for the tips.

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

    hanks,

    avidFan
    avidfan Guest

Similar Threads

  1. ERROR 1064 when trying to load dump from sql file
    By docw@globetrotter.net in forum MySQL
    Replies: 3
    Last Post: October 22nd, 09:56 PM
  2. Replies: 0
    Last Post: January 29th, 02:03 PM
  3. mySQL error
    By khansab in forum Dreamweaver AppDev
    Replies: 14
    Last Post: September 16th, 10:04 PM
  4. mySQL error in PHP that works directly in mySQL
    By jcg in forum PHP Development
    Replies: 2
    Last Post: May 25th, 10:58 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139