select 'replace into t_seed_url(seed_url)values(''www.'||site_url||''');' from t_result_site; 这条语句在oracle中是可以执行的, 我想让查询结果里自动打印出一条插入语句 我想让大侠帮我编辑下类似语句,在mysql里能执行的
select concat('replace into t_seed_url(seed_url)values(''www.',site_url,''');') from t_result_site;
mysql> select concat('insert into t_seed',' values(\'www.site_url\')',' from t_result_site;'); +---------------------------------------------------------------------------------+ | concat('insert into t_seed',' values(\'www.site_url\')',' from t_result_site;') | +---------------------------------------------------------------------------------+ | insert into t_seed values('www.site_url') from t_result_site; | +---------------------------------------------------------------------------------+ 是要这效果吗?
+---------------------------------------------------------------------------------+
| concat('insert into t_seed',' values(\'www.site_url\')',' from t_result_site;') |
+---------------------------------------------------------------------------------+
| insert into t_seed values('www.site_url') from t_result_site; |
+---------------------------------------------------------------------------------+
是要这效果吗?