Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2012
    Posts
    1

    Red face Unanswered: Error #1064, no clue what to do... Please Help!

    I am running XAMPP on windows and when I try and import a file to create tables in the db, I get this error,

    #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 '\g create table performers (performer_name varchar(255) not null, producer_serv' at line 1

    Here is the first line in the file:

    create table producers (producer_server varchar(255) not null, type varchar(255) not null, version varchar(255), login varchar(255) not null, password varchar(255) not null, dbase varchar(255) not null, name varchar(255), address varchar(255))\g

    Someone Please Help Me...

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    WELL FIRST OFF i'D TRY REMOVING THE \G
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    caps lock key b0rk3n, healdem?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by healdem View Post
    WELL FIRST OFF i'D TRY REMOVING THE \G
    That sounds like a great plan to me!

    R937, somedays when you want to really make a point... UPPERCASE HELPS MAKE THAT POINT!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by r937 View Post
    caps lock key b0rk3n, healdem?
    the GUI (the bodged interface) between the optical sub system, the main processing unit and filewriter subsystem failed. or put another way I din't see it
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Change the DELIMITER to \g
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  7. #7
    Join Date
    Apr 2005
    Posts
    29
    Yes - you can remove the \g and you should be fine.

    Once you have it created you can show status information on a table.

    Code:
    mysql> show create table A_Test\G
    show create table A_Test\G
    *********************************
    Table: A_Test
    Create Table: CREATE TABLE `A_Test` (
    `pkey` int(11) NOT NULL auto_increment,
    `a` int(11) default NULL,
    `b` int(11) default NULL,
    `c` int(11) default NULL,
    `timeEnter` timestamp NOT NULL,
    PRIMARY KEY  (`pkey`),
    UNIQUE KEY `a` (`a`,`b`)
    ) TYPE=MyISAM DEFAULT CHARSET=latin1
    1 row in set (0.00 sec)
    Web Database Software - Build your own php mysql database.

Posting Permissions

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