i ve tried:
update videos set video_active=1, video_approve=1, video_type='private' where video_approve=0;

and

update video set video_active=1, video_approve=1, video_type='private' where video_approve=0;

result:

#1146 - Table '********_vshare.videos' doesn't exist
#1054 - Unknown column 'video_approve' in 'where clause'