mysql生成insert into语句

SELECT
CONCAT(
‘INSERT INTO wth.wth_attachment (attachment_id, file_name, size, height, width, path, type, md5, title, content, beginTime, endTime) VALUES (’
‘’’’,id,’’’,’,
‘’’’,if(file_name is null,‘0000’,file_name),’’’,’,
‘’’’,if(size is null,‘0000’,size),’’’,’,
‘’’’,if(height is null,‘0000’,height),’’’,’,
‘’’’,if(width is null,‘0000’,width),’’’,’,
‘’’’,if(path is null,‘0000’,path),’’’,’,
‘’’’,if(type is null,‘0000’,type),’’’,’,
‘’’’,if(md5 is null,‘0000’,md5),’’’,’,
‘’’’,if(title is null,‘0000’,title),’’’,’,
‘’’’,if(content is null,‘0000’,content),’’’,’,
‘’’’,if(beginTime is null,‘0000’,beginTime),’’’,’,
‘’’’,if(endTime is null,‘0000’,endTime),’’’’,
‘);’
)
from vip.vip_attachment