updating a table ......?

[altaf]

hi there,

Wherenver I try to update a table using sql statement, it doesn't work.

TABLE - abc

ID NAME
___________
1 hello
12 abc

sql statement is :

UPDATE `abc` SET `ID`='5' AND `NAME`='hello' WHERE `ID`='1' AND `NAME`='hello'

Any idea why? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Reed]

The update syntax is:

UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1 [, col_name2=expr2 ...]
[WHERE where_condition]
[ORDER BY ...]
[LIMIT row_count]

Put a comma instead of "AND" making the query

UPDATE `abc` SET `ID`='5',`NAME`='hello' WHERE `ID`='1' AND `NAME`='hello' -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --