Re: SQL file,
| From: | Brad Bonkoski | Date: | Sat, 21 Sep 2002 13:18:16 +0000 |
| Subject: | Re: SQL file, | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21888@lists.php.net to get a copy of this message | ||
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