Forum Moderators: coopster

Message Too Old, No Replies

PHP and MySQL

         

Kysmiley

2:09 am on Oct 23, 2004 (gmt 0)

10+ Year Member



I'm kind of confused after reading a book on PHP and MySQL. The book shows how to create the database and setup the tables with from the command line, yet it also appears to have setup a file name.sql file with the create tables in it. I am wondering if I am able to just use my text editor and place the create table commands in it aslong as i name it with an .sql ext. The refer to this file via my PHP scripts. I sure home this question makes sence I am not able to find my answer doing a search thru the many posts.
Pat

coopster

4:44 pm on Oct 23, 2004 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



The name.sql example is just another way of Loading Data into a Table [dev.mysql.com]. It's referred to as Batch Mode [dev.mysql.com].

mincklerstraat

5:15 pm on Oct 23, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



You'll probably want to get phpmyadmin which will let you use these .sql files. Inside of PHP, you'll want to use CREATE queries.