Re: If statement for sql statement
| From: | Marij Bellen | Date: | Wed, 10 Apr 2002 11:03:27 +0000 |
| Subject: | Re: If statement for sql statement | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18379@lists.php.net to get a copy of this message | ||
see mysql.com for an insert select synthax.
maybe that helps.
6.4.3.1 INSERT ... SELECT Syntax
INSERT [LOW_PRIORITY] [IGNORE] [INTO] tbl_name [(column list)] SELECT ...
With INSERT ... SELECT statement you can quickly insert many rows into a
table from one or many tables.
INSERT INTO tblTemp2 (fldID) SELECT tblTemp1.fldOrder_ID FROM tblTemp1 WHERE
tblTemp1.fldOrder_ID > 100;
MVG Marij B.