Options for inserting and updating mysql

[drooh]

Is it possible to do something like this?

$sql = "UPDATE `test` SET (`name`,`age`) VALUES ('Sam','34') WHERE `id` = 10";

It would be nice because the insert command is similar

$sql = "INSERT INTO `test` (`name`,`age`) VALUES ('Sam','34')";

[drooh]

Or vise versa, is there a way to

$sql = "INSERT INTO `test` (`name`='sam',`age`='34')";

[coopster]

Have you checked the optional syntax?
[dev.mysql.com...]

[drooh]

not really seeing an answer there? Can you specify some code or be more specific?

[coopster]

Second syntax example is almost exactly what you typed in your second post ...

INSERT INTO test SET name = 'sam', age = 34;

[drooh]

Ok, thank you, I wish they could write their examples like that. For some reason that mysql website is just so hard for me to read.

Somehow

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name
SET col_name={expr | DEFAULT}, ...
[ ON DUPLICATE KEY UPDATE
col_name=expr
[, col_name=expr] ... ]

Just doesnt register in my brain.

thanks for you post and letting me know this is possible.

[drooh]

This was exactly what I was looking for, this way I can re-use a portion of the query for inserting and updating.

Just out of curiosity at this point, is there a way to do something like this?

$sql = "UPDATE `test` SET
(
`name`,
`age`
)
VALUES
(
'Pete',
'34'
)
WHERE `id` = 10
";

[coopster]

not according to the syntax ...
[dev.mysql.com...]

Regarding reading the manuals and understanding the syntax ...
[dev.mysql.com...]