|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
July 13th, 2005, 05:59 AM
|
|||
|
|||
|
Creating an SQL table from another table
've been stuggling with getting an Apache server running, along with PHP and MySQL on XP Home, but almost there. I created a MySQL database, but need to decrypt this bit of advice
$ mysql test < tables.my.sql where test is the name of my database and tables.my.sql is supplied. I think it means it's trying to create predefined tables within my database from the supplied table. I'm not sure exactly what to type in. SQl 4.0.21. Anybody help ?
|
|
#2
July 13th, 2005, 02:48 PM
|
|||
|
|||
|
That syntax is for running mysql query commands from an existing text file. For example, say you've got a database called 'test' (which you should). Create a text file called 'create_test1.sql' with the following:
Code:
CREATE TABLE test1 ( id INT, myfoo VARCHAR(50)); Now, from your windows command line (not your mysql command line), type: mysql test < create_test1.sql This will run the query(ies) contained in create_test1 into the database test -- in this example, you've created the table test1. In the context of your situation, I'm not sure what you need. If you don't have any text files you want to run, then you don't need to use this syntax.
__________________
"A pawn is the most important piece on the chessboard -- to a pawn"
|
|
| Viewing: Dev Articles Community Forums > Databases > General SQL Development > Creating an SQL table from another table |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
