how to do a query using a file?

2001-04-30 Thread mario . lat
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.

Re: how to do a query using a file?

2001-04-30 Thread Sofiane Sakhri
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

Re: how to do a query using a file?

2001-04-30 Thread mario . lat
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

Re: how to do a query using a file?

2001-04-30 Thread Shawn Cummings
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 If you