|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
May 7th, 2003, 01:39 PM
|
|||
|
|||
MySQL scripts
In Oracle you can write an SQL procedure to create a table, in notepad for example, and save it as a script, 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 in MySQL.
In Oracle you create the script, save it then type SQL> @filename.sql What is the file format in MySQL? And how do I run said file from the MySQL prompt?
|
|
#2
May 7th, 2003, 02:18 PM
|
||||
|
||||
|
You should have posted this question to the appropriate (MySQL) forum.
From the command line: mysql -u user -p database_name < path\yourfile.sql
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias) Last edited by pabloj : May 7th, 2003 at 02:20 PM.
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > MySQL scripts |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
