Hey All,
Is there a problem doing an update to two tables in the same query in mysql 3.23?
I run this:
SQL-query :
UPDATE products,
images SET products.pro_aprov = 'n',
images.pro_name = 'Demo',
images.image_name = '9.jpg',
images.image_size = '14334',
images.image_type = 'image/jpeg',
images.image_path = 'upload_images/troinfo61/9.jpg' WHERE images.pro_id = '9' AND products.pro_id = '9'
MySQL said:
#1064 - You have an error in your SQL syntax near '
images SET products.pro_aprov = 'n',
images.pro_name = 'Demo',
images.image_n' at line 1
and get the error.
However if I run this on two other pc that have mysql 4.0 it works fine.
Is it ok to do queries like this?
Also has anyone ever tried using transactions with Innodb tables and is it hard to change from the mysiam table type to Innodb?
Thanks,
Troinfo
