oracle 对应的MySQL的语句
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里可以，但是却不能改属性的名字。
SQL code:
create table book1 select book_name,price form book;
SQL code:
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: 0
mysql> select * from t4;
+----+------+
| id | f |
+----+------+
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
+----+------+
3 rows in set (0.00 sec)
mysql>
SQL code:
mysql> create table book1 as select name as testname from a;
Query OK, 6 rows affected (0.22 sec)
Records: 6 Duplicates: 0 Warnings: 0
mysql> select * from book1;
+----------+
| testname |
+----------+
| chen |
| chen |
| zhao
相关问答：
做个站内搜索，现在用like 这样的效率实在太低了，想改成全文搜索方式。
但看了网上说的中文支持不好，想问一下各位兄弟是如何解决这个问题的？
单独建立主题表和内容表 检索主题
然后根据主题检索� ......
在MySQL5.0中船舰存储过程通不过，提示：
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' ......
我之前导入的数据库，现在删除不了，用了命令行和工具都不行，重启也不行，这是为什么呢？
你是如何删除的？
有什么提示？
问题说明越详细，回答也会越准确！参见如何提问。（提问的智慧）
......
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里可以，但是却� ......
