fejl i INSERT INTO

INSERT INTO (tablename.field1) VALUES (1) WHERE tablename.field11 = "10101";

/askhoej

Ups sådan her:

INSERT INTO tablename (tablename.field1) VALUES (1) WHERE tablename.field11 = "10101";

Du blander to typer insert sammen:

insert into (tablename.field1) values (1)

insert into (tablename.field1) select "1" where tablename.field11 = "10101"

Du skal bruge den nederste, hvis du vil have den where med.

Sorry, insert into tablename ...

UPDATE tablename SET field1 = "1" WHERE field11 = "10101"

INSERT INTO tablename (tablename.field1) VALUES (1) WHERE tablename.field11 = "10101";

virker ik' får fejl om den ikke er afsluttet med semikolon

INSERT INTO tablename (tablename.field1) SELECT "1" WHERE tablename.field11 = "10101";

virker ik' får fejl om syntax error (missing ooerator)

viperfx102, you can NOT INSERT into an existing record (WHERE)
you have to use UPDATE for existing records and INSERT for NEW

Takker!

selv tak :o)