Results 1 to 4 of 4
  1. #1

    Question mysql Error Number : 1064

    hi all,

    are mysql Error Number : 1064 because i use mysql 4 not 5?

    thanks in advance for help

  2. #2
    Join Date
    Oct 2004
    Location
    Shimonoseki
    Posts
    2,101
    Can you give us the query you are running?
    Closed for winter...

  3. #3
    That's the reserved keyword error. So, yes, sometimes you will get that error when using newer mysql applications built for mysql5 because mysql5 and mysql4 have a different set of reserved words.

    If you post the query, we can be sure that's what you're seeing.

  4. #4
    Join Date
    May 2009
    Posts
    766
    Here's the reserved word list for MySQL 4.x:

    http://dev.mysql.com/doc/refman/4.1/...ved-words.html

Similar Threads

  1. Email error - error number 0x800CCC79 server response 451 temporary local problem
    By Server-Needs in forum Hosting Security and Technology
    Replies: 3
    Last Post: 11-22-2008, 08:32 AM
  2. 1064: You have an error in your SQL syntax
    By lbeachmike in forum Programming Discussion
    Replies: 2
    Last Post: 11-02-2008, 07:13 PM
  3. MySQL Error : Got error -1 from storage engine Error Number : 1030
    By Linkdatacenter in forum Programming Discussion
    Replies: 2
    Last Post: 05-25-2008, 04:16 AM
  4. PHP+mySQL... adding a number to an existing number
    By crEA-tEch in forum Programming Discussion
    Replies: 1
    Last Post: 04-16-2004, 01:06 PM
  5. mysql error number: 1064
    By Meow Meow in forum Programming Discussion
    Replies: 2
    Last Post: 11-26-2002, 01:46 AM

Posting Permissions

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