Re: FN-FORUM another simple mysql problem

date posted 27th April 2001 17:54

Rob,
It is the missing semicolon above it!

Have a good weekend!
David
----- Original Message -----
From: [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Friday, April 27, 2001 5:10 PM
Subject: FN-FORUM another simple mysql problem


> does anyone know why this .sql file won't import into a mysql database?
It seems to come up with errors concerning the date, date right from the
start.
>
> thanks in advance
>
> Rob
>
> use shopmob;
>
> create table members(
> mem_no int(11) primary key not null,
> name char(30),
> address1 char(50),
> address2 char(50),
> address3 char(50),
> postcode char(10),
> tel_no char(20),
> emerg_name char(20),
> emerg_no char(20),
> email char(40),
> last_use date,
> notes char(250));
>
> create table scaft(
> date date,
> day char(15),
> s1 char(10),
> s2 char(10),
> s3 char(10),
> s4 char(10),
> s5 char(10),
> s6 char(10),
> s7 char(10),
> s8 char(10),
> s9 char(10),
> s10 char(10),
> s11 char(10))
>
> create table scmid(
> date date,
> day char(15),
> s1 char(10),
> s2 char(10),
> s3 char(10),
> s4 char(10),
> s5 char(10),
> s6 char(10),
> s7 char(10),
> s8 char(10),
> s9 char(10),
> s10 char(10),
> s11 char(10))
>
> create table scmorn(
> date date,
> day char(15),
> s1 char(10),
> s2 char(10),
> s3 char(10),
> s4 char(10),
> s5 char(10),
> s6 char(10),
> s7 char(10),
> s8 char(10),
> s9 char(10),
> s10 char(10),
> s11 char(10))
>
> create table wcmorn(
> date date,
> day char(15),
> s1 char(10),
> s2 char(10))
>
> create table wcmid(
> date date,
> day char(15),
> s1 char(10),
> s2 char(10))
>
> create table wcaft(
> date date,
> day char(15),
> s1 char(10),
> s2 char(10))
>
> create table scooters(
> number int(11) primary key,
> wheelno char(3),
> maxpay char(5),
> speed char(10),
> colour char(20),
> notes char(250),
> fault char(3),
> lastuse char(10))
>
> create table wheelchairs(
> number int(11) primary key,
> maxpay int(11),
> colour char(20),
> notes char(250),
> fault char(3),
> lastuse char(10))
>
>
>
> ============================================================
>
> * Free listing for freelancers
> * Free to advertise jobs
> * Free jobs distribution service
> * Free database of 1000 freelancers
>
> Freelancers and Freelance Jobs
> http://www.freelancers.net
>
> To post to the Forum:
> [EMAIL REMOVED]
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>
> To subscribe to the digest for this list or for further information please
visit:
> http://www.freelancers.net/forum.html
>