数据库 sql

添加数据库字段sql
/*#mycat:sql=select * from points_order_paypal */
alter table points_order_paypal add  txn_id VARCHAR(32) not null UNIQUE



DELETE from points_order_paypal
修改总段
/*#mycat:sql=select * from points_order_paypal */
ALTER TABLE points_order_paypal ALTER COLUMN txn_id   SET DEFAULT ''

查找token
SELECT * from user_session ORDER BY last_login_time desc limit 5

修改字段的唯一性
show index from points_order_paypal
/*#mycat:sql=select * from points_order_paypal */
alter table points_order_paypal drop index txn_id

修改字段的类型
/*#mycat:sql=select * from wifiin_card_modify_history */
alter table wifiin_card_modify_history modify modify_time varchar(50);

当前时间
update recommendation_relationship set reference_date=(select now()) where id=1

增加删除字段
/*#mycat:sql=select * from hotspot_gather_day_count */
alter table hotspot_gather_day_count add  sdk_partner_id int not null default '-1'
/*#mycat:sql=select * from hotspot_gather_day_count */
alter table hotspot_gather_day_count drop column sdk_partner_id

删除数据
delete from action where parentid in (21,23,412,424,425,486,487,488,489)

查询字段问空
ifnull(update_time,'1997-01-01') as updateTime
order by updateTime desc

删除一个表
DROP TABLE table-name

建表
/*#mycat:sql=select * from tableName */