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
mysql生成insert into语句
最新推荐文章于 2024-07-22 03:04:14 发布