From: julian <jkbowler@...>
Date: 2006-03-30T03:08:42+09:00
Subject: Re: using mysql client to read a file to create a table in a database in a mysql server

The air is clearing, or what ever the expression is.
When you want to run the mysql client to read or interrpret a flat file
I think you need some thing like:
depot>    mysql -h 127.0.0.1 -u root -p depot_development
<db/create.sql

You press return and then the prompt asks for a password, in this case
it is the root password, I entered that and there was no errors wow....
thats more like it!!!

The depot_development is the name of the database, (which I guess must
exist on the server!?) However the flat file with the sql in myst live
in the db directory.
the next question is where is the db directory,
the answer is under directory depot , under directory ruby.
The version of mysql server I am using is 4.1.16nt under tcp/ip
The other problem I had was a syntax error in the create.sql file i had
as part of the table price decimal(10.2) not null, but is should be
price decimal(10,2) , i.e. using a comma.
I am a bit of a newcommer to this so on a massive steep learning curve,
but you help Avatar was very much appreciated indeed Thanks a lot ta
brill ta excellent  etc..