Query error

[macacoloco]

UPDATE t_characters SET a_char_index WHERE a_index = %d

query error : query[uPDATE t_characters SET a_char_index WHERE a_index = 358] / error[You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE a_index = 358' at line 1]

 

 

 

Is fixed: UPDATE t_characters SET a_char_index = a_index WHERE a_index = %d

 

Second query:

 

UPDATE t_characters SET a_char_index = %d, a_assassinatos = %d, a_assassinatos2 = %d, a_assassinatos3 = %d, a_assassinatos4 = %d

 

 

 

 

Someone can help for fix this pls? I need update only 1 character no all characters

[peter3301]

like this:

update t_characters set a_char_index = 999999999 where a_index = 123321123321;

[macacoloco]

thx, but this values is in auto predefined...

 

 

like this:

update t_characters set a_char_index = 999999999 where a_index = 123321123321;

Ex: "UPDATE t_characters SET a_char_index = a_index WHERE a_index = %d"

running : UPDATE t_characters SET a_char_index = a_index WHERE a_index = index char use

Ex2: UPDATE t_characters SET a_char_index = %d, a_assassinatos = %d, a_assassinatos2 = %d, a_assassinatos3 = %d, a_assassinatos4 = %d
running: UPDATE t_characters SET a_char_index = index char use, a_assassinatos = points kill 1, a_assassinatos2 = points kill 2, a_assassinatos3 = points kill 3, a_assassinatos4 = points kill 4

 

 

 

the problem is all chars update, i like only 1 update
 

 

 

 

 

2, 0, 2, 2, 358 need update only for 1 line, all line has updated

[macacoloco]

I write all source for new query and work fine now, thx

[Nymphetamine]

Closed