mysql insert as select_在MySQL中使用INSERT ... SELECT添加额外的列值

I have two tables and my goal is to move specific data from the first table into the second table along with a reason for why that data was moved. For instance:

raw_data_table

SELECT * FROM raw_data_table where id IS NULL;

I would want to move this into the second table, which is identical to the first table except for an extra column reason. I tried:

INSERT INTO bad_data_table

(SELECT * FROM raw_data_table WHERE id IS NULL), "The ID is NULL";

But this returns a syntax error. How can I copy the entire row over and add the reason value?

解决方案INSERT INTO bad_data_table

SELECT *, 'The ID is NULL' AS Reason

FROM raw_data_table

WHERE id IS NULL;