Shulou(Shulou.com)06/02 Report--

This article mainly shows you "how SQL insert to select data", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how SQL insert to select data" this article.

Today, we need to insert a piece of data, but the content comes to a select statement. After querying, we come to the following conclusion.

INSERT INTO `directoryId` (`directoryId`, `roleId`) select id,1 from `directory` where `consoleUrl` = 'toCreateAwardPool.action'

Note that the data to be inserted before needs to correspond to the number of parameters to be queried later

The above is all the contents of the article "how SQL insert data from select". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.