Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to use into in mysql". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn how to use into in mysql.

Into in mysql means "turn into". The into keyword is generally used with the select statement to assign the retrieved value to a variable, that is, the data value is transformed into a variable value, so that the variable represents the query result, and the syntax is "Select*Into data value from variable value".

The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.

What does into mean in mysql

Into is generally used in conjunction with select statements in mysql

Assign the retrieved value to a variable so that the variable represents the query result.

The syntax is as follows:

Select * Into new_table_name from old_table_name

Examples are as follows:

SELECT `name` INTO @ name FROM student WHERE `id` = 14; SELECT @ name

The implementation results are as follows:

Thank you for your reading, the above is the content of "how to use into in mysql". After the study of this article, I believe you have a deeper understanding of how to use into in mysql, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.