MySQL inserts the data that is queried in table A into table B
If Table B exists
1 |
<code class= "SQL" ><code class= "SQL" ><code class= "SQL" >insert into a b select * from a;</code>< /code></code> |
If Table B does not exist
1 |
<code class= "SQL" ><code class= "SQL" ><code class= "SQL" ><code class= "SQL ><code class=" sql "><code class=" SQL >create table B as select * FROM a;</code></code></code></code> </code></code> |
Extended:
Insert the value of a write segment in table B into Table A
1 |
<code class= "SQL" ><code class= "SQL" ><code class= "SQL" ><code class= "SQL ><code class=" sql "><code class=" SQL ><code class= "SQL" ><code class= "SQL" ><code class= "SQL" ><code class = "SQL" ><code class= "SQL" >insert into a (userid,username) select B.userid,b.username from Tr_ajax_chat_ Messages;</code></code></code></code></code></code></code></code ></code></code></code> |
Save a table and B table UserID equal values to table a
1<code class= "SQL" ><code class= "SQL" ><code class= "SQL" ><code class= "SQL" ><code class= "SQL" ><code class= "SQL" ><code class= "SQL" > <code class= "SQL" ><code class= "SQL" ><code class= "SQL" ><code class= "SQL ><code class=" sql "><code class=" SQL ><code class= "SQL" ><code class= "SQL" ><code class= "SQL" ><code class = "SQL" ><code class= "SQL" >update a set a.username= (select B.username from b where A.userid = B.userid); </code& Gt;</code></code></code></code></code></code></code></code> </code></code></code></code></code></code></code></code></ code> |
&NBSP; |