[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-developer
Subject:    running scripts !
From:       Jani Tolonen <janikt () saunalahti ! fi>
Date:       1999-06-22 20:29:32
[Download RAW message or body]

Keith Wong writes:
 > hi ppl..
 > 
 > sorry i'm a newbie with mysql..
 > 
 > but is there a way to run a sql script in mysql to create a database...
 > i.e. a script file containing create table sql statements..? much like
 > how oracle creates databases...
 > 
 > i know you can populate the tables from a text file... but i want to run
 > sql statements from a text file..
 > 
 > is this possible on mysql.?
 > 
 > cheers,
 > Keith.
 > 

Hello Keith,

shell> mysql [data_basename] < your_sqlcommands.sql

Regards,

- Jani

-- 
+---------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___                                |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|       Jani Tolonen             |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|       mailto: jani@mysql.com   |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|       Helsinki                 |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|_____  Finland                  |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                           |
|             /*/             \*\                   Developers Team   |
+---------------------------------------------------------------------+

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail developer-thread91@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail developer-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic