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 trade of Oracle Corporation and/or its affiliates. Other names may be trades 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>
使用了use dbname,先进了数据库,结果还是要select * from order_info.order;
mysql> use order_info Database changed mysql> select * from order; ERROR 1064 (42000):
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 trade of Oracle Corporation and/or its
affiliates. Other names may be trades 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>
Database changed
mysql> select * from order;
ERROR 1064 (42000):