mysql - give a query as value (dynamic value)

Question

Can I give a query as a value in mysql?

I meen something like this:

UPDATE table1 SET val='X'

where

X= SELECT COUNT(page) AS X FROM table2 WHERE order_no=1

so every time I ask for X it should depend on other tables content

John Woo · Accepted Answer · 2012-09-11 15:34:26Z

1

You can do subquery for your value, example

UPDATE table1 
SET val = (
           SELECT COUNT(page) 
           FROM table2 
           WHERE order_no = 1
          )

answered Sep 11, 2012 at 15:34

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

I got this: Warning: #1366 Incorrect integer value: '(SELECT COUNT(page) FROM table2 WHERE id=1)' for column 'fajlok_szama' at row 1