How to add static value when doing INSERT INTO with SELECT in a MySQL query? August 12, 2023 by Tarik SELECT 4 will give you 4, so try: INSERT INTO db2.b (x,y,z) SELECT x,y,4 FROM db1.a