auto_increment in mysql

[jjliu]

i have created the following table:

create table test (field1 varchar(100), id integer unsigned not null
auto_increment, unique (field1), primary key (id));

When i try to insert some values by using the following statement

insert into test values ("this is a test");

I was told "column count does not match value count at row 1".

I could not figure out what's wrong with the syntax. Could someone help me
out. Thanks.

[BDR]

You can't use that type of syntax when inserting into one field only.

Using a blatant insert into, your input value count MUST match the
number of columns in the table, like this:

insert into test values "this is a test", '0'

This type of insert is not recommended because if your database ever
changes, then all of your programmed query statements will have to
change too.

Better:
insert into test (field1), ("this is a test")

or
insert into test (field1), ("this is test1", "this is test2", "this is
test3")

or

insert into test set field1="this is a test"

jjliu wrote:

i have created the following table:

create table test (field1 varchar(100), id integer unsigned not null
auto_increment, unique (field1), primary key (id));

When i try to insert some values by using the following statement

insert into test values ("this is a test");

I was told "column count does not match value count at row 1".

I could not figure out what's wrong with the syntax. Could someone help me
out. Thanks.

[BDR]

You can't use that type of syntax when inserting into one field only.

Using a blatant insert into, your input value count MUST match the
number of columns in the table, like this:

insert into test values "this is a test", '0'

This type of insert is not recommended because if your database ever
changes, then all of your programmed query statements will have to
change too.

Better:
insert into test (field1), ("this is a test")

or
insert into test (field1), ("this is test1", "this is test2", "this is
test3")

or

insert into test set field1="this is a test"

jjliu wrote:

i have created the following table:

create table test (field1 varchar(100), id integer unsigned not null
auto_increment, unique (field1), primary key (id));

When i try to insert some values by using the following statement

insert into test values ("this is a test");

I was told "column count does not match value count at row 1".

I could not figure out what's wrong with the syntax. Could someone help me
out. Thanks.

[KS]

On Mon, 13 Oct 2003 19:54:53 +0000, jjliu wrote:

insert into test values ("this is a test");

If I remember correct you must list the fields in insert clause. So the
correct sql would be
insert into test(field1) values ("this is a test");

-Kari

[KS]

On Mon, 13 Oct 2003 19:54:53 +0000, jjliu wrote:

insert into test values ("this is a test");

If I remember correct you must list the fields in insert clause. So the
correct sql would be
insert into test(field1) values ("this is a test");

-Kari