Kurt,
You can name the file whatever you want, with whatever extension you want.
To run the file from within mysql:
MYSQL> source filename
Hope that helps,
Sam
>Shoot me now. In Oracle you can write an SQL procedure, in notepad
>for example, to create a table. You can then save this file in case
>you need to recreate the table later. The problem I am having is the
>naming of the file format and what command to use to run the file
>from the MySQL command prompt.
>
>In Oracle you type
>
>SQL> @filename.sql
>
>What do I name the file?
>How to I run the file?
>
>Thanks
>
>Kurt
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=1
--
----------------------------------------------------------------
|Sam A. Funk http://www.samafunk.com sfunk@stripped|
|Wichita, KS Guitarist (self-proclaimed) Macintosh Fanatic|
|Kansas Bluegrass Association http://www.kansasbluegrass.org/ |
----------------------------------------------------------------
