Αποτελέσματα Αναζήτησης
Learn how to use the SQL SELECT INTO statement to copy data from one table into a new table. See syntax, examples and tips for different scenarios and databases.
Learn how to use SELECT ... INTO to store query results in variables or write them to a file. See the syntax, options, and examples of this form of SELECT.
24 Ιουν 2024 · Learn how to use the SELECT INTO statement in MySQL to retrieve data from a table and store it in another table or in variables. See syntax, examples, and FAQs on this SQL feature.
17 Οκτ 2021 · INSERT INTO this_table_archive (col1, col2, ..., coln) SELECT col1, col2, ..., coln. FROM this_table. WHERE entry_date < '2011-01-01 00:00:00'; MySQL Documentation.
This tutorial shows you how to use the MySQL SELECT INTO variable to store query result in one or more variables.
MySQL Server does not support the SELECT ... INTO TABLE Sybase SQL extension, but the INSERT INTO ... SELECT standard SQL syntax instead. Learn how to use INSERT INTO ... SELECT, SELECT ... INTO OUTFILE, CREATE TABLE ... SELECT, and SELECT ... INTO with user-defined variables.
To do select into in MySQL, use CREATE TABLE SELECT command. The syntax is as follows −. CREATE TABLE yourTableName SELECT *FROM yourOriginalTableName; To understand, let us first create a table −.
