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

In this issue, the editor will bring you about how to use query results to create tables in MySQL. The article is rich in content and analyzed and described from a professional point of view. I hope you can get something after reading this article.

MYSQL does not support:

Select * Into new_table_name from old_table_name

Alternative method:

one

Create table new_table_name (Select * from old_table_name)

Select * into new_table_name from old_table_name

two

SELECT * INTO OUTFILE 'a.txt' FROM table_name

LOAD DATA INFILE'/ database//a.txt' INTO TABLE new_table_name

This is how to use the query results to create tables in the MySQL shared by the editor. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are 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.