Just wondering if there is a way to combine insert into using select & values. I have a table with say 5 columns. I want to insert into 4 columns from another table from but for 1 column insert manually (say 55 for all the rows in that column).
Is there a way to do this apart from using:
INSERT INTO table1 (c1,c2,c3,c4)
SELECT a1,a2,a3,a4 FROM table2
and then UPDATE c5 in table 1.
but is there a way to do this in 1 query (maybe using Values)?