Error #1064, no clue what to do... Please Help!

ccie04 · #1 (**permalink**) 02-10-12, 19:53

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...

healdem · #2 (**permalink**) 02-10-12, 20:15

WELL FIRST OFF i'D TRY REMOVING THE \G

r937 · #3 (**permalink**) 02-10-12, 20:37

caps lock key b0rk3n, healdem?

Pat Phelan · #4 (**permalink**) 02-10-12, 21:02

Quote:

Originally Posted by healdem

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

healdem · #5 (**permalink**) 02-11-12, 05:57

Quote:

Originally Posted by r937

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

it-iss.com · #6 (**permalink**) 02-12-12, 04:17

Change the DELIMITER to \g

sonic10 · #7 (**permalink**) 02-12-12, 10:01

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)

Internet Services

Web Development

Digital Marketing

Consumer Tech