[Outros] mudança em char com sql

[italope]

[SIZE="2"]tipo si eu entendi oq vc quis dizer a melhor forma e assim o

[insert into] `characters` SET `pkkills`='1' WHERE (`char_name`='fulano');
[insert into]`characters` SET `pkkills`='1' WHERE (`char_name`='sicrano');

obs:o insert into vc ira usar em todas as linhas si for fazer o update de 5 char vai usar 5 vezes insert into
outra obs: ; vc sempre deve usar no final de cada linha[/SIZE]

----------

[SIZE="2"]um exmplo aki o

Spoiler

INSERT INTO `characters` VALUES ('italope', '268479418', '-=Admin=-MASTER', '80', '5881', '5881', '3977', '3977', '1754', '1754', '33', '40', '33', '3', '47', '213', '4', '72', '330', '126', '88', '42', '45', '30', '21', '25', '11', '0', '4', '0', '0', '38727', '82954', '148490', '-3469', '1.00000000', '1.000000000', '9.000', '23.000', '6299994998', '0', '29867146', '0', '0', '0', '0', '864686', '0', '92', '92', '0', '0', '', '0', '9', '200', '0', '69499', null, '1', '1279489962093', '0', '0', '0', '0', '0', '0', '0', '0', '1279468800265', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0');
INSERT INTO `characters` VALUES ('jadopaz', '268479501', '=ADM=LosKaralhos', '80', '6338', '6338', '3602', '3602', '1723', '1640', '33', '40', '33', '3', '47', '213', '4', '72', '330', '126', '88', '42', '45', '30', '21', '25', '11', '1', '3', '1', '0', '43116', '82778', '147834', '-3469', '1.00000000', '1.000000000', '9.000', '23.000', '6299994998', '0', '2147483647', '0', '1000', '1000', '0', '576457', '0', '90', '90', '0', '0', 'OoJadooO', '0', '9', '200', '0', '32999', null, '1', '1279379198109', '0', '0', '0', '0', '0', '0', '0', '0', '1279296138828', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0');
INSERT INTO `characters` VALUES ('thiago14', '268479335', '.::ADM::.Bucetinha', '80', '4316', '4316', '2780', '2780', '1173', '1173', '33', '40', '33', '3', '48', '203', '4', '72', '327', '125', '87', '39', '45', '29', '20', '27', '10', '1', '0', '2', '1', '63477', '143408', '110169', '-3954', '1.00000000', '1.000000000', '9.000', '18.000', '6299994998', '0', '96', '0', '0', '0', '0', '1152915', '4', '53', '53', '0', '0', '', '0', '9', '200', '0', '12689', null, '1', '1279485908421', '0', '0', '0', '0', '0', '0', '0', '0', '1279471375453', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0');
INSERT INTO `characters` VALUES ('italo', '268479080', 'NomeColor', '80', '12315', '12315', '4719', '4719', '2171', '2171', '33', '40', '33', '3', '47', '213', '4', '72', '330', '126', '88', '40', '43', '30', '21', '25', '11', '0', '1', '0', '0', '59020', '83397', '148581', '-3405', '1.00000000', '1.000000000', '9.000', '23.000', '6299994998', '6299994998', '0', '0', '5050', '5050', '0', '543373', '0', '89', '89', '0', '0', '', '0', '9', '0', '0', '3986', null, '1', '1279490162625', '0', '0', '0', '0', '0', '0', '0', '0', '1279471351828', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '', '0', '0', '0', '0');

[/SIZE]