Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010
    Posts
    15

    Unanswered: Problem to run insert

    Hi,
    I get this error

    Error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' store_dscr = '033002', stockout_time = current_timestamp' at line 1
    Error number: 1064

    when running "Insert" against Mysql database. why?
    Many Thanks & Best Regards,
    HuaMin Chen

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    can we see the full query? not just the bit from the error message
    its a syntax error, so the message is telling you where the MySQL engine gave up, but that isn't necessarily the source of the error.

    it would also help if you provide details of the table design including column datatypes
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jan 2010
    Posts
    15
    Many thanks.
    Last edited by HuaMin; 07-17-15 at 00:25.
    Many Thanks & Best Regards,
    HuaMin Chen

Posting Permissions

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