如下面所未,我create database test也没有效果show database也没有,很是郁闷。C:\Documents and Settings\Administrator>mysql -u root -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 53 to server version: 5.0.18-ntType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> show database
->
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 53 to server version: 5.0.18-ntType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> show database
->
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 53 to server version: 5.0.18-ntType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> show database
-> show databases
-> show databases;
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 'datab
ase
show databases
show databases' at line 1
mysql> show database;
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 'datab
ase' at line 1
mysql>
以上是我按你们要求做的,还是没有效果啊
谢谢,兄弟。还有我想查询某个数据库下的某一个表怎么办?
查询的结果会在dos窗口上显示吗?怎么查询啊?谢谢。
show tables; //显示所有表
desc aa; //描述aa表结构.
select * from aa ; //查询aa表中所有数据建议去学学mysql基本语法。。
晕死,mysql我也搞一年多了,基本语还不懂吗,只不过一直没有在cmd里使用,你在这发有什么用,在cmd里支持一下,然后把显示的贴上来。
真搞
mysql>准备好接受新命令。
->等待多行命令的下一行。
";"表示语句结束.
MySQL手册第三章.
装个SQlyog吧 在里面执行比用那个CMD 舒服多了...