>From the command line you can load syntax from a file
mysql -u [username] -p [database] < filename.txt
On Mon, 30 Apr 2001 [EMAIL PROTECTED] wrote:
> > query: load data local infile "file.txt" into table
> > my_table
>
> Thank you.
> But for creating an entire and complex database?
> I mean
> query: load data local infile "file.txt" into table
> my_table
Thank you.
But for creating an entire and complex database?
I mean If you have to create 40 table?!?
there is a way to do it by ascii file?
I write the SQL commands once and then I can recreate the db whth tables in
different compu
He, you can download the documentation file from
http://www.lri.fr/~aze/PHP/docs/ or others and see
the example chapter,
In my case, I Store my Access data base in a text file
and upload to my serveur, then I execute this sql
query: load data local infile "file.txt" into table
my_table
it works
I have to buitd a "big" database.
I have to create table,
insert row in database and then do the same thing on another computer.
I'd like to do that using a file in whiich I write all ...
but how can I do?
Thank you in advance. Mario.
--