Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Error 1064

forums › forums › SQLyog › Using SQLyog › Error 1064

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • October 29, 2006 at 11:28 pm #9999
      ResolvCo
      Member

      Error occured at:2006-10-29 16:31:01

      Line no.:30

      Error Code: 1064 – 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 'INSERT INTO `urban_business` VALUES (1, 'STEVE/ CHRIS', 'JACKSO

      Here's line #30

      INSERT INTO `urban_business` VALUES (1, 'STEVE/ CHRIS', 'JACKSON/EVANSON', '', 'CEI ELECTRICAL & MECHANICAL', '2900 E 13TH STREET', '', '4||8||6', 'KANSAS CITY', 'MO', '64127', '816', '221-0006', '816-221-0191', '', '', '', 1, 'SAME AS ABOVE', '3/6/2007', '06/06/2007', '', 1, 'd5fdfce9cf773b2abace1ca2e5aa2390', '0000-00-00 00:00:00')

    • October 30, 2006 at 5:09 am #22874
      peterlaursen
      Participant

      please:

      * tell the SQLyog version

      * tell what operation you are doing.

      * also: can you reproduce the problem – still have the case?

      * please also attacte the CREATE statement for the table to ensure that we test with EXACTLY the same datatypes as you have.

      actually the MySQL parser is not very accurate always. So the actual error could be in the line before!

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.