1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2000
    Rep Power
    Hi there,

    Just wondering if anyone could help? I'm trying to install a MySQL database and getting nowhere fast.. It's basically an address-book type thing.. one primary key BigNum (unique, primary) and some text fields (I think binary [not at all sure about this] not null and so on. I get this error message.

    MySQL said: You have an error in your SQL syntax near '(50) BINARY DEFAULT 'Company' not null , location TEXT (80) BINARY DEFAULT 'Loc' at line 1

    Anyone know what settings I'm doing wrong? It's a single-table database (nothing too complex to start with!!) and it's driving me mad!

    Cheers guys,

  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2000
    Montreal, Canada
    Rep Power
    Can you include the exact query you made?

Similar Threads

  1. Replies: 5
    Last Post: February 2nd, 2005, 12:28 AM
  2. UTF-8 problem in 4.1.1a
    By mehran20 in forum MySQL Help
    Replies: 1
    Last Post: February 8th, 2004, 02:21 PM
  3. fread problem: doesn t compile php code
    By ghorghor2002 in forum PHP Development
    Replies: 2
    Last Post: February 3rd, 2004, 05:25 AM
  4. WinNT4 problem
    By sandipguha in forum Windows Help
    Replies: 0
    Last Post: January 27th, 2004, 02:06 AM
  5. weird java problem..please help
    By suwandy in forum Java Help
    Replies: 1
    Last Post: January 26th, 2004, 04:13 AM

IMN logo majestic logo threadwatch logo seochat tools logo