|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#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 about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) Understanding SQL Joins An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries 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
