Inserting a row with a value from another table

Hello readers, I was wondering if there is a feature in MySQL that allows us to insert a row with only some values from another table. INSERT...SELECT syntax helps to insert multiple rows and it seems not to allow any constant values. Let's clarify the case with an example. I have a table of

Re: Inserting a row with a value from another table

Ville Mattila wrote: Hello readers, I was wondering if there is a feature in MySQL that allows us to insert a row with only some values from another table. INSERT...SELECT syntax helps to insert multiple rows and it seems not to allow any constant values. Let's clarify the case with an