SQL-Update-Statement

[Christian Freitag]

Hello!
I have a litte problem with my sql-database!
I have to update all UA-fields in the table idrz_kennzahl with primary
key idrz, where the same idrz in the table per_verwaltung with the
field Amt=12 is.

I designed following statement but it doesn't work:

update idrz_kennzahl
set UA=1234
where
idrz_kennzahl.idrz =
(SELECT per_verwaltung.idrz from per_verwaltung where
per_verwaltung.Amt=12)
Does anybody has an idea for my prob - sorry i'm an mysql-newbie!

Thanks,
Christian

[Richard Wilson]

ch*******@web.de (Christian Freitag) wrote:

Hello! I have a litte problem with my sql-database! I have to update all
UA-fields in the table idrz_kennzahl with primary key idrz, where the same
idrz in the table per_verwaltung with the field Amt=12 is.

I designed following statement but it doesn't work:

update idrz_kennzahl set UA=1234 where idrz_kennzahl.idrz = (SELECT
per_verwaltung.idrz from per_verwaltung where per_verwaltung.Amt=12)
In good tradition, I've not time to test it, but try using:

UPDATE idrz_kennzahl, perverwalting SET idrz_kennzahl.UA=1234 WHERE
idrz_kennzahl.idrz=per_verwaltung.idrz AND per_verwaltung.Amt=12;

Does anybody has an idea for my prob - sorry i'm an mysql-newbie!

MySQL doesn't support sub-SELECTs. It's detailed in the accompanying
documentation somewhere in the UPDATE bit.

R.
--
Richard Wilson, Publications Manager
Tradelink Publications Ltd.

[Richard Wilson]

ch*******@web.de (Christian Freitag) wrote:

Hello! I have a litte problem with my sql-database! I have to update all
UA-fields in the table idrz_kennzahl with primary key idrz, where the same
idrz in the table per_verwaltung with the field Amt=12 is.

I designed following statement but it doesn't work:

update idrz_kennzahl set UA=1234 where idrz_kennzahl.idrz = (SELECT
per_verwaltung.idrz from per_verwaltung where per_verwaltung.Amt=12)
In good tradition, I've not time to test it, but try using:

UPDATE idrz_kennzahl, perverwalting SET idrz_kennzahl.UA=1234 WHERE
idrz_kennzahl.idrz=per_verwaltung.idrz AND per_verwaltung.Amt=12;

Does anybody has an idea for my prob - sorry i'm an mysql-newbie!

MySQL doesn't support sub-SELECTs. It's detailed in the accompanying
documentation somewhere in the UPDATE bit.

R.
--
Richard Wilson, Publications Manager
Tradelink Publications Ltd.

[Richard Wilson]

ch*******@web.de (Christian Freitag) wrote:

Hello! I have a litte problem with my sql-database! I have to update all
UA-fields in the table idrz_kennzahl with primary key idrz, where the same
idrz in the table per_verwaltung with the field Amt=12 is.

I designed following statement but it doesn't work:

update idrz_kennzahl set UA=1234 where idrz_kennzahl.idrz = (SELECT
per_verwaltung.idrz from per_verwaltung where per_verwaltung.Amt=12)
In good tradition, I've not time to test it, but try using:

UPDATE idrz_kennzahl, perverwalting SET idrz_kennzahl.UA=1234 WHERE
idrz_kennzahl.idrz=per_verwaltung.idrz AND per_verwaltung.Amt=12;

Does anybody has an idea for my prob - sorry i'm an mysql-newbie!

MySQL doesn't support sub-SELECTs. It's detailed in the accompanying
documentation somewhere in the UPDATE bit.

R.
--
Richard Wilson, Publications Manager
Tradelink Publications Ltd.

[Aggro]

Richard Wilson wrote:

MySQL doesn't support sub-SELECTs. It's detailed in the accompanying
documentation somewhere in the UPDATE bit.

MySQL supports sub selects, starting from version 4.1

http://www.mysql.com/doc/en/ANSI_diff_Subqueries.html

[Aggro]

Richard Wilson wrote:

MySQL doesn't support sub-SELECTs. It's detailed in the accompanying
documentation somewhere in the UPDATE bit.

MySQL supports sub selects, starting from version 4.1

http://www.mysql.com/doc/en/ANSI_diff_Subqueries.html

[Aggro]

Richard Wilson wrote:

MySQL doesn't support sub-SELECTs. It's detailed in the accompanying
documentation somewhere in the UPDATE bit.

MySQL supports sub selects, starting from version 4.1

http://www.mysql.com/doc/en/ANSI_diff_Subqueries.html