Quote:
Originally Posted by FapMax
he is offering nothing and have simple questions like "can you fix my SQL Command ?"
his question
my fix
|
You don't need to specify the table name in the where statement, and it saves a lot of time typing if you just specify which database to use at the start. Other then that seems to me he should of just made a support thread.
Code:
USE newproject_data;
UPDATE t_item SET a_flag = '60' WHERE a_flag = '62';
UPDATE t_item SET a_flag = '89' WHERE a_flag = '91';
UPDATE t_item SET a_flag = '25' WHERE a_flag = '27';
UPDATE t_item SET a_flag = '124' WHERE a_flag = '126';
UPDATE t_item SET a_flag = '24' WHERE a_flag = '26';
UPDATE t_item SET a_flag = '2172' WHERE a_flag = '2174';
UPDATE t_item SET a_flag = '40' WHERE a_flag = '42';
UPDATE t_item SET a_flag = '265' WHERE a_flag = '267';
UPDATE t_item SET a_flag = '281' WHERE a_flag = '283';
UPDATE t_item SET a_flag = '9' WHERE a_flag = '11';
UPDATE t_item SET a_flag = '40' WHERE a_flag = '42';
UPDATE t_item SET a_flag = '3132' WHERE a_flag = '3134';
UPDATE t_item SET a_flag = '60' WHERE a_flag = '134742078';