添加纪录问题；

[global_boy]

我用create database创建了一个库member并建了2个表users和password；
当我用insert into users values("user1",password("1234"));添加纪录时出现如下提示：
ERROR 1136: Column count doesn't match value count at row 1
请问该如何解决？


:)

[alsoran]

你的users表的结构是什么样？

[global_boy]

char(20)

[alsoran]

怎么就这一个字段？
那你的语句可能有问题吧。。

[global_boy]

create table users (
username char(20) not null,
password char(20) not null,
);

[alsoran]

一个表可以完全解决你的问题的，建立两个字段 user和password
都设置成char

语句这样写应该就可以了
insert into users values("user1","yourpassword");

[shuixin13]

insert into users values("user1",password("1234"));
与你的users表结构不一样呀，
插入一定不行的

[global_boy]

mysql> insert into users values("admin","admin");
ERROR 1136: Column count doesn't match value count at row 1

[alsoran]

可能是你表建的有问题
describe users;
看一下你表的结构

[global_boy]

mysql> use member;
Database changed
mysql> describe users;
+----------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+----------+------+-----+---------+-------+
| username | char(20) | | | | |
+----------+----------+------+-----+---------+-------+
1 row in set (0.00 sec)

[global_boy]

mysql> describe password;
+----------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+----------+------+-----+---------+-------+
| password | char(20) | | | | |
+----------+----------+------+-----+---------+-------+
1 row in set (0.00 sec)

[alsoran]

你的users表只有一个username字段，上面的一定是不行啊，如果要插入的话只能是插入一个值
insert into users values("admin");

你该建一个表包含两个字段的，username 和password

create table users2 (
username char(20),
password char(20),
);

再插入该没问题了insert into users2 values("admin","admin");

[alsoran]

可以这么建表也create
table users2 (
username varchar(20),
password varchar(20),
);

[global_boy]

thanks very much!

[global_boy]

mysql> use member
Database changed
mysql> create table users2 (
-> username char(20),
-> password char(20),
-> );
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near ')' at line 4

[global_boy]

mysql> create
-> table users2
-> (
-> username varchar(20),
-> password varchar(20),
-> )
-> ;
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near ')' at line 6

[shuixin13]

咱们一个个来：
1、
mysql> insert into users values("admin","admin");
ERROR 1136: Column count doesn't match value count at row 1
解答：
这是因为在你的users表中只有一个字段，而你在插入时却写了两个字段，
所以报表的Column数与你所给定的值数目不匹配

2、
mysql> create
-> table users2
-> (
-> username varchar(20),
-> password varchar(20),
-> )
-> ;
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near ')' at line 6

解答：
因为你的SQL语句错了，你只定义了两个字段，“password varchar(20),”这句最后的“，”就不要了，
标准为
CREATE TABLE users (username VarChar(20), password VarChar(10));

[shuixin13]

新学数据库吧，
用MySQL最好的，
它配置简单，
SQL也与标准差不多


建议看看这个，

SQL循序渐进
http://surpass.swpi.edu.cn/article/SQLst.zip