MySQL syntax error... please help - GoFuckYourself.com

spacedog · 04-04-2007, 01:39 AM

I'm trying to load these tables vrun sql queries & I get this error message;

"MySQL said:

#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 "

I have no idea how to fix this. Can anyone help?

Here is the queries

Code:

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

create table performers (performer_name varchar(255) not null, producer_server varchar(255) not null, date_of_birth date not null, last_name varchar(255) not null, first_name varchar(255) not null, id_document_url varchar(255) not null, pic_url varchar(255))\g

create table depictions (depiction_name varchar(255) not null, producer_server varchar(255) not null, depiction_date date not null, depiction_type varchar(255) not null, copy_url varchar(255) not null)\g

create table depiction_urls (depiction_name varchar(255) not null, producer_server varchar(255) not null, url varchar(255) not null)\g

create table aliases (performer_name varchar(255) not null, producer_server varchar(255) not null, alias varchar(255) not null, alias_type varchar(255) not null)\g

create table audit_trail (edit_date timestamp not null, login varchar(32) not null, command varchar(255) not null)\g

create table logins (login varchar(32) not null, password varchar(32), login_type int not null)\g

create table inspections (inspection_date date not null, credentials varchar(255), nature varchar(255), purpose varchar(255), scope varchar(255), violations varchar(255), copies varchar(255))\g

create table depiction_performers (depiction_name varchar(255) not null, performer_name varchar(255) not null, producer_server varchar(255) not null)\g

insert into logins values('xxxxxx', 'xxxxxx', 3)\g

much appreciated

hjnet · 04-04-2007, 02:41 AM

Don't know where you're trying to run these queries, but a proper SQL query should look like:

create table 'producers' ('producer_server' varchar(255) not null);

so it depends how you're trying to run these queries, but you might wanna check your syntax

spacedog · 04-04-2007, 02:50 AM

Quote:

Originally Posted by hjnet

Don't know where you're trying to run these queries, but a proper SQL query should look like:

create table 'producers' ('producer_server' varchar(255) not null);

so it depends how you're trying to run these queries, but you might wanna check your syntax

Well, the script instructions say to generate tables via;

shell > mysqladmin -h <host> -u <user> -p create <dbname>
Enter password: *******
shell > mysql -h <host> -u <user> -p <dbname> < load_tables
Enter password: *******

but that's all greek to me, so took the file named load_tables & tried running it as queries.

artware · 04-04-2007, 03:08 AM

You could try it by replacing the "\g" at the end of each line with a semicolon ";".

spacedog · 04-04-2007, 04:25 AM

Quote:

Originally Posted by artware

You could try it by replacing the "\g" at the end of each line with a semicolon ";".

That worked.. thank you.

04-04-2007, 02:41 AM	#2
hjnet Confirmed User Join Date: May 2002 Location: European Union Posts: 3,815	Don't know where you're trying to run these queries, but a proper SQL query should look like: create table 'producers' ('producer_server' varchar(255) not null); so it depends how you're trying to run these queries, but you might wanna check your syntax

04-04-2007, 03:08 AM	#4
artware Confirmed User Join Date: Oct 2002 Location: the Netherlands Posts: 268	You could try it by replacing the "\g" at the end of each line with a semicolon ";".