数据库 sql
来源:互联网 发布:淘宝店铺装修背景图 编辑:程序博客网 时间:2024/04/28 08:26
添加数据库字段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 */
/*#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 */
0 0
- SQL数据库
- SQL数据库
- sql数据库
- 数据库SQL
- sql数据库
- sql 数据库。。。
- 数据库SQL
- sql数据库
- SQL数据库
- sql数据库
- SQL数据库
- SQL 数据库
- SQL数据库
- sql数据库
- 数据库SQL
- SQL数据库
- SQL数据库
- SQL数据库
- OpenSSL中RSA的简易加解密流程
- XQuery
- 【muduo网络库学习】之Acceptor类分析
- scala属性的getter和setter方法
- Android Design Support Library
- 数据库 sql
- centos7忘记root密码
- 2016.6.15笔记(3)- Ant的基础知识
- ELK安装
- window窗口消息大全
- ajax跨域访问
- ERROR! The server quit without updating PID file (/var/lib/mysql//localhost.localdomain.pid
- dell服务器服务器数据丢失后,数据恢复
- Log4j ConversionPattern参数的格式含义