updating two tables?

[muller]

Hi all,
Please tell me whether i can update two tables? The below update statement matched 2 rows one each for two tables but didn't update.

mysql> update audio,pcr_info on audio.audio_sid=pcr_info.pcr_sid set audio.
audio_pid=4896,audio.audio_prgm_num=3,audio.audio_ type="MPEGLayer1",audio.audio_
sr=44.1,audio.audio_mode="1_0",audio.audio_bitrate =320,pcr_info.pcr_pid=49 where
pcr_info.pcr_prgm_num=3 and pcr_info.pcr_sid="2501" and audio.audio_pid=4896 an
d pcr_info.pcr_pid=49;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 2 Changed: 0 Warnings: 0 -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Thalian]

It seems that the rows probably already had the correct values in them. ` -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --