MySQL5.5 数据库名.表名的问题

[Alan S1]

为什么在MySQL新版本5.5里面，

在Command Line Client里面每次 select * from tableA都不允许了，
只能 select * from 数据库名.表名。
如何去掉前面的数据库名.前缀呢？

[ACMAIN_CHM]

你有没有 use dbname ?

[xzg_sql]

应该如楼上所说

[rucypli]

use dbname先进数据库

[Alan S1]

Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 122
Server version: 5.5.15 MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use order_info
Database changed
mysql> select * from order;
ERROR 1064 (42000): 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 'order
' at line 1
mysql>

[Alan S1]

使用了use dbname，先进了数据库，

结果还是要select * from order_info.order;

[Alan S1]

mysql> use order_info
Database changed
mysql> select * from order;
ERROR 1064 (42000):

[superhosts]

mysql5.5与mysql5.1有什么不同，能举出几列吗？要点

[ACMAIN_CHM]

ORDER 是保留字！

select * from `order`;