MySQL question

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
cooler75
Forum Commoner
Posts: 40
Joined: Wed May 29, 2002 2:43 pm
Location: RichIsland

MySQL question

Post 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
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post by volka »

some (most?) mysql-frontend support those files.
I'm using mysql-front
cooler75
Forum Commoner
Posts: 40
Joined: Wed May 29, 2002 2:43 pm
Location: RichIsland

Post 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
User avatar
cwcollins
Forum Commoner
Posts: 79
Joined: Thu May 16, 2002 3:51 pm
Location: Milwaukee, WI, USA

Post 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
cooler75
Forum Commoner
Posts: 40
Joined: Wed May 29, 2002 2:43 pm
Location: RichIsland

Post by cooler75 »

mysql-front works like a pro :)

thank you

I will check out

using mysql in batch mode

Thanks
honkyinc
Forum Newbie
Posts: 19
Joined: Tue Jun 04, 2002 10:30 am
Location: Maryland, USA

Post 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)
Post Reply