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,
Advertising
> 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
