orcle 语句 create table book1(name, price) as select book_name, price form book;
对应的MySQL的语句是什么 create table book1 as select book_name, price form book; 这样在MySQL里可以,但是却不能该属性的名字。
对应的MySQL的语句是什么 create table book1 as select book_name, price form book; 这样在MySQL里可以,但是却不能该属性的名字。
mysql> select * from t1;
+---+------+---------+
| a | f | message |
+---+------+---------+
| 1 | 1 | Testing |
| 2 | 2 | table |
| 3 | 3 | t1 |
+---+------+---------+
3 rows in set (0.11 sec)mysql>mysql> create table t4 as select a as id,f from t1;
Query OK, 3 rows affected (0.11 sec)
Records: 3 Duplicates: 0 Warnings: 0mysql> select * from t4;
+----+------+
| id | f |
+----+------+
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
+----+------+
3 rows in set (0.00 sec)mysql>当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html