Page 1 of 1

MySQL question

Posted: Mon Jun 03, 2002 2:23 pm
by cooler75
Hi all,
I downloaded a script from hotscripts.com

There is a file called createtable.sql , it's asking me to load into the database.

I know the hard way, i can manually create tables and insert values by typing it in using mysql.exe

Is there any way I can just import the createtable.sql file into the database without typing it in manually?

thank you

Posted: Mon Jun 03, 2002 2:35 pm
by volka
some (most?) mysql-frontend support those files.
I'm using mysql-front

Posted: Mon Jun 03, 2002 2:41 pm
by cooler75
Thanks, i am downloading it right now

But, i guess there is no easy way where you can just type in some type of a comment line to load data from createtable.sql?

thanks, i will give it a try

Posted: Mon Jun 03, 2002 3:14 pm
by cwcollins
Sure there is...
http://www.mysql.org/documentation/mysq ... Batch_mode

c.w.collins

cooler75 wrote:Thanks, i am downloading it right now

But, i guess there is no easy way where you can just type in some type of a comment line to load data from createtable.sql?

thanks, i will give it a try

Posted: Mon Jun 03, 2002 3:23 pm
by cooler75
mysql-front works like a pro :)

thank you

I will check out

using mysql in batch mode

Thanks

Posted: Tue Jun 04, 2002 10:32 am
by honkyinc
You can also, depending on which version of it you might be running, use PHPMyAdmin to select the file and it will process it automatically. I know you've found a solution, but others might have an interest in other "front-ends" ;o)