RE: [PHP] quicky sql question
| From: | Cynic | Date: | Thu, 21 Dec 2000 10:27:28 +0000 |
| Subject: | RE: [PHP] quicky sql question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-31392@lists.php.net to get a copy of this message | ||
Jason,
INSERT INTO ... SET ...
is completely valid syntax.
Marc, what's the error you get?
At 05:28 21.12. 2000, Jason Murray wrote the following:
--------------------------------------------------------------
>> What is wrong with this SQL query
>>
>> INSERT INTO com_site SET (UID='' , ACTIVE='1' , TITLE='test')
>
>It's completely malformed, is whats wrong :)
>
>INSERT INTO com_site (UID, ACTIVE, TITLE)
>VALUES ('', '1', 'test');
>
>Looks like your original statement is mixing INSERT and UPDATE syntax.
>
>Jason
>
>--
>Jason Murray
>jasonm@melbourneit.com.au
>Web Design Team, Melbourne IT
>Fetch the comfy chair!
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
>For additional commands, e-mail: php-general-help@lists.php.net
>To contact the list administrators, e-mail: php-list-admin@lists.php.net
------end of quote------
____________________________________________________________
Cynic:
A member of a group of ancient Greek philosophers who taught
that virtue constitutes happiness and that self control is
the essential part of virtue.
cynic@mail.cz