I don't think it quite works that way through PHP. You could send the _contents_ of the file through PHP, like open the file, and read it into a buffer, and send that as a query. I actually create the files and then go into my database system (MySQL -or- PostgreSQL) and then execute a command. I think for MySQL it is: mysql> \i <name_of_file> and then that will step through the file executing the SQL statements. -Brad
Advertising
Bryan McLemore wrote: > So I would send the file through with a sql query? > > -Bryan > ----- Original Message ----- > From: "Brad Bonkoski" <[EMAIL PROTECTED]> > To: "Bryan McLemore" <[EMAIL PROTECTED]> > Cc: "PHP DB LIST" <[EMAIL PROTECTED]> > Sent: Saturday, September 21, 2002 8:18 AM > Subject: Re: [PHP-DB] SQL file, > > > Typically, it is a text file that has SQL in it. > > Like: > > CREATE DATABASE some_name ( > > ID int NOT NULL AUTO_INCREMENT PRIMARY KEY, > > NAME varchar(30), > > etc.... > > > > Usually they are used to store the database information, and can be used > in many of the database systems. Within the database itself, there is a > command to insert from a file. Not sure off the top of my head, but the > help menu should provide that > > information, then the database would go through your file and execute > those commands as if you were entering them in manually on the command line. > Espescially helpful for huge tables where you might be open to a typo, and > have to start all over. > > HTH > > -Brad > > > > Bryan McLemore wrote: > > > > > in an example I saw in a book while I was leafing through it at barnes > and nobles I saw a .sql file. It appeared to have the schema for a db in > it. I was wondering what exactly what it is and how one could use it in a > php application like he was doing. > > > > > > Thanks, > > > Bryan > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
