Beginning MySQL Tutorial
One of the fastest SQL (Structured Query Language) database servers currently on the market is the MySQL server, developed by T.c.X. DataKonsultAB. MySQL, available for download at http://www.mysql.com, offers the data base programmer with an array of options and capabilities rarely seen in other database servers. What's more, MySQL is free of charge for those wishing to use it for private and commercial use.
| Name: |
L. Aleaume |
| Subject: |
CREATE...INSERT... |
| Date: |
07-06-1999 07:28AM |
High,
I just begin to enjoy MySQL but I meet somme problems with the syntax of:
[code]
CREATE foo_new_table (foo_id int not null)
SELECT foo_id from foo_old_table;
[/code]
Indeed, MySQL answers :
[code]
ERROR 1064 at line 182: you have an error in your SQL syntax near 'select foo_id from foo_old_table;
[/code]
i don't really undestand since the column type of the new one is the same as the old one (describe foo_old_table).
regards,
Luc
|
Other posts in this thread:
Reply to this post:
|
 |
Visit the MySQL Forum!
New On DevShed:
Hot Forum Topics:
|
