Data from Sql:insert to select

You need to insert a piece of data today, but the content comes to a SELECT statement and is queried to draw the following conclusions

INSERT into ' Role_directory_rel ' (' Directoryid ', ' Roleid ') select id,1 from ' directory ' where ' consoleurl ' = ' Tocreateawardpool.action ';

Note that the data you want to insert in the previous query corresponds to the number of arguments

This article is from the "technical Achievements of Life" blog, please be sure to keep this source http://2933246.blog.51cto.com/2923246/1763025

Data from Sql:insert to select