删除表DROP TABLE IF EXISTS jc_user;
删除字段alter table jc_user drop column username;
新增字段alter table jc_user add column code varchar(50);
alter table jc_user add column login_count int(11) default 0;
删除外键alter table jc_user drop FOREIGN KEY fk_jc_user_message;
把查询出来字段值更新到另一张表update jc_demand d set d.order_time = (select create_time from jc_order o where o.demand_id = d.id);
把查询出来的统计值更新到另一张表update jc_comment comment ,(select *,count(*) counts from jc_comment_reply group by comment_id) reply
set comment.reply_count = reply.counts where comment.comment_id = reply.comment_id;
把查询出来字段值插入到另一张表insert into jc_company_category (company_id,category_id)
select id, type_id from jc_company where id not in (select distinct company_id from jc_company_category);
把字段所有值加上一个字符串#oracle
update etec_menu set menu_url = 'bpm'||menu_url where url_type = 'url';
#mysql
update etec_menu set menu_url = concat('bpm',menu_url) where url_type = 'url';