How to get data from another piece in mysql

In this issue, the editor will bring you about how to get data from another piece of mysql. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

Method one

CREATE TABLE tmp AS SELECT a.id FROM t_user t JOIN temp an ON t.email = a.email

Method two

INSERT INTO t_user (id,username,PASSWORD,email,user_type,STATUS) SELECT id,REPLACE (email,'@','_'), PASSWORD,email,'0','0' FROM temp

Both sql are inserted into the current table with data obtained from the other.

This is how to get data from another piece of 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.