安装成功了 并能够做表了too many paramenters -Files 不知道这是什么意思,如何解决?
C:\AppServ\MySQL>cd binC:\AppServ\MySQL\bin>mysql -u root -p Enter password: ******* Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 5.0.27-community-nt-logType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> use mytest; Database changed mysql> CREATE TABLE `b` ( -> `text` varchar(20) NOT NULL -> ) ENGINE=MyISAM DEFAULT CHARSET=gb2312; Query OK, 0 rows affected (0.08 sec)mysql> INSERT INTO `a` VALUES ('2text'); Query OK, 1 row affected (0.00 sec)mysql> select * from b; Empty set (0.00 sec)
insert错表了mysql> select * from b; Empty set (0.00 sec)mysql> INSERT INTO `b` VALUES ('2text'); Query OK, 1 row affected (0.00 sec)mysql> select * from b; +-------+ | text | +-------+ | 2text | +-------+ 1 row in set (0.00 sec)
并能够做表了too many paramenters -Files 不知道这是什么意思,如何解决?
C:\AppServ\MySQL>cd binC:\AppServ\MySQL\bin>mysql -u root -p
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.0.27-community-nt-logType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> use mytest;
Database changed
mysql> CREATE TABLE `b` (
-> `text` varchar(20) NOT NULL
-> ) ENGINE=MyISAM DEFAULT CHARSET=gb2312;
Query OK, 0 rows affected (0.08 sec)mysql> INSERT INTO `a` VALUES ('2text');
Query OK, 1 row affected (0.00 sec)mysql> select * from b;
Empty set (0.00 sec)
Empty set (0.00 sec)mysql> INSERT INTO `b` VALUES ('2text');
Query OK, 1 row affected (0.00 sec)mysql> select * from b;
+-------+
| text |
+-------+
| 2text |
+-------+
1 row in set (0.00 sec)