[PHP] MySQL - UPDATE INSERT

[Phil Schwarzmann]

Is this query legal?
 
$query = UPDATE table SET (var1, var2, var3) VALUES ($var1, $var2,
$var3) WHERE username='$username';
 
 
Im wondering cause I have an INSERT query
 
$query = INSERT INTO table (var1, var2, var3) VALUES ($var1, $var2,
$var);
 
...but only there are like 150 different variables and it will take me
forever to write a query like
 
$query = UPDATED table SET var1='$var1', var2='$var2', var3='$var3'
WHERE username='$username';
 
THANKS!

Re: [PHP] MySQL - UPDATE INSERT

[Julie Meloni]

The UPDATE syntax in the manual:

http://www.mysql.com/doc/U/P/UPDATE.html

UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1, [col_name2=expr2, ...]
[WHERE where_definition]
[LIMIT #]

Yes, it is different than the INSERT syntax.

PS ...but only there are like 150 different variables and it will take me
PS forever to write a query like

Therein lies your problem - quite likely you need to normalize!


- Julie

-- Julie Meloni
-- [EMAIL PROTECTED]
-- www.thickbook.com

Find Sams Teach Yourself MySQL in 24 Hours at
http://www.amazon.com/exec/obidos/ASIN/0672323494/thickbookcom-20


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] MySQL - UPDATE INSERT

[Rick Emery]

what happened when you tried your query?

-Original Message-
From: Phil Schwarzmann [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 12:58 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL - UPDATE  INSERT


Is this query legal?
 
$query = UPDATE table SET (var1, var2, var3) VALUES ($var1, $var2,
$var3) WHERE username='$username';
 
 
Im wondering cause I have an INSERT query
 
$query = INSERT INTO table (var1, var2, var3) VALUES ($var1, $var2,
$var);
 
...but only there are like 150 different variables and it will take me
forever to write a query like
 
$query = UPDATED table SET var1='$var1', var2='$var2', var3='$var3'
WHERE username='$username';
 
THANKS!

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] MySQL - UPDATE INSERT

[Erik Price]

On Friday, April 5, 2002, at 01:58  PM, Phil Schwarzmann wrote:

 Is this query legal?

 $query = UPDATE table SET (var1, var2, var3) VALUES ($var1, $var2,
 $var3) WHERE username='$username';

No.  The SET modifier (or whatever that is) can only be used to create 
column name/value relationship pairs.  To my knowledge, your syntax 
above (which looks similar to INSERT INTO table (..., ..., ...) 
VALUES (..., ..., ...)) cannot be used for UPDATE statements.

 Im wondering cause I have an INSERT query

 $query = INSERT INTO table (var1, var2, var3) VALUES ($var1, $var2,
 $var);

 ...but only there are like 150 different variables and it will take me
 forever to write a query like

 $query = UPDATED table SET var1='$var1', var2='$var2', var3='$var3'
 WHERE username='$username';

If you have shell access to your database server, you can always CREATE 
TEMPORARY TABLE and test things out on a small scale, then DROP TABLE 
when you're done playing.


Erik







Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php