Into in mysql means "convert 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 converted into a variable value, so that the variable represents It is 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
In mysql, into is generally used with the select statement
to retrieve the retrieved value Assign a 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;
The example is as follows:
SELECT `name` INTO @name FROM student WHERE `id`=14 ; SELECT @name
The execution results are as follows:
Recommended learning: mysql video tutorial
The above is the detailed content of What does into mean in mysql. For more information, please follow other related articles on the PHP Chinese website!