GoFuckYourself.com - Adult Webmaster Forum - MySQL syntax error... please help

- Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)

- - MySQL syntax error... please help (https://gfy.com/showthread.php?t=721017)

MySQL syntax error... please help

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

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 :)

Quote:

Originally Posted by hjnet (Post 12192516)

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.

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

Quote:

Originally Posted by artware (Post 12192565)

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

That worked.. thank you. :thumbsup :thumbsup :thumbsup