вложенный запрос

[alexey84]

вложенный запрос

возможно ли написать подобный запрос, если да, то как правильнее?
INSERT INTO s1_tSiteCounters SET ordersOrder=SELECT MAX(countersOrder) AS max1 FROM s1_tSiteCounters

 

[alpine]

alexey84
http://dev.mysql.com/doc/refman/5.0/en/subqueries.html

Another restriction is that currently you cannot modify a table and select from the same table in a subquery. This applies to statements such as DELETE, INSERT, REPLACE, UPDATE, and (because subqueries can be used in the SET clause) LOAD DATA INFILE.

 

[Апельсин]

используйте INSERT .. SELECT:
INSERT INTO s1_tSiteCounters(ordersOrder) SELECT MAX(countersOrder) FROM s1_tSiteCounters;

 

[alexey84]

а как быть если надо заполнить два поля, так выдает ошибку
INSERT INTO s1_tSiteCounters(countersOrder, countersName) SELECT MAX(countersOrder)+1 FROM s1_tSiteCounters, '1'

 

[Wicked]

SELECT MAX(countersOrder)+1, 1 FROM s1_tSiteCounters

 

[alexey84]

спасиба!