2013ǯ11��01��
MySQL select��̤�update����
�פϥ쥳���ɤ���Ф��Ƥ��Υ�����¾�Υ쥳���ɤ˥��ԡ�����������SQL�ˤʤ�ޤ���
UPDATE top r,
(SELECT sp_text_1,sp_text_2,sp_text_3,sp_text_4 FROM top where language = 'ja') x SET
r.sp_text_1 = x.sp_text_1,
r.sp_text_2 = x.sp_text_2,
r.sp_text_3 = x.sp_text_3,
r.sp_text_4 = x.sp_text_4
WHERE
r.language <> 'ja'
��󡢤ɤ���äƽ񤯤Τ�˺��Ƥ��ޤ���������