Differences

This shows you the differences between two versions of the page.

Link to this comparison view

mysqlinsertselect [2016/05/09 15:00]
yassine chaouche created
mysqlinsertselect [2016/05/09 15:01] (current)
yassine chaouche
Line 5: Line 5:
  
 <​code>​ <​code>​
-mysql> INSERT INTO mail.users (email,​maildir,​password,​quota) ​ SELECT email,​maildir,​password,​quota FROM dbispconfig.mail_user;​+mysql> INSERT INTO mail.users (email,​maildir,​password,​quota)  ​ 
 +SELECT email,​maildir,​password,​quota ​ 
 +FROM dbispconfig.mail_user;​
 Query OK, 566 rows affected (0.07 sec) Query OK, 566 rows affected (0.07 sec)
 Records: 566  Duplicates: 0  Warnings: 0 Records: 566  Duplicates: 0  Warnings: 0

QR Code
QR Code mysqlinsertselect (generated for current page)