Dear All,
I need to update the data's from one table(my_channels) to another table(all_package).
I i used the following code. UPDATE all_packages SET channels = 'my_channels.ch_name' WHERE channels != 'my_channels.ch_name'
0 row(s) affected. ( Query took 0.0004 sec )
Please help....
Update one table to another
Moderator: General Moderators
Re: Update one table to another
Code: Select all
UPDATE all_packages SET channels = 'my_channels.ch_name' WHERE channels != 'my_channels.ch_name'Code: Select all
UPDATE all_packages SET channels = my_channels.ch_name WHERE channels != my_channels.ch_nameRe: Update one table to another
What is it that you are trying to do? That SQL looks to me like it would never work, even after correcting for the quotes. Please explain what you are trying to achieve.