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