1.添加外键约束语句
alter table user add BANK_ID BIGINT(20);//添加一栏
alter table user add constraint FK_user_bank foreign key (BANK_ID) references bank_card(id); 添加外键
alter table TRAIN_EXPENSEINFO modify column EXPID int comment '报销单ID'; 添加mysql属性别名
https://blog.csdn.net/fat_cai_niao/article/details/97136934 mysql学习笔记(3):多表创建及多表之间的关系(外键约束)
2.删除外键与索引(下表设置)
删除外键与索引
alter table base_pay drop foreign key FK585d6mtp8akpxar7qn6gmwae7;
ALTER TABLE base_pay DROP INDEX FK585d6mtp8akpxar7qn6gmwae7;
添加外键,自动添加索引
alter table base_pay add constraint `FK585d6mtp8akpxar7qn6gmwae7` foreign key (`user_id`) references user(`USER_ID`);
3.右连接,内连接查询(https://blog.csdn.net/plg17/article/details/78758593 图解MySQL 内连接、外连接、左连接、右连接、全连接……太多了)
select * from base_salary basesalary0_
right outer join user user1_
on basesalary0_.user_user_id=user1_.user_id
inner join base_pay basepayent2_
on user1_.base_pay_id=basepayent2_.base_pay_id
where 1=1
结果如下图,信息如下图连接(左连与内连)
...。..。....。
4.
添加:
alter table 表名 add 字段名 varchar(32) comment '备注名';
alter table project add COMPANY_CONTYPE varchar(10) comment '内部合同类型';
删除:
alter table 表名 drop column 列名;
alter table project drop column COMPANY_CONTYPE;
5.
https://blog.csdn.net/lqz790192593/article/details/87928875 MySQL5.7.17安装及配置图文教程 dos命令在安装的mysql目录下bin下输入,检查版本信息和是否安装成功(默认安装路径在:C:\Program Files\MySQL\MySQL Server 5.7\bin)
6.mysql每半个小时查询一次(记录数)
SELECT
HOUR (e.writingtime) AS HOUR,
COUNT(id)
FROM
biz_crl_monitor_account_data e
WHERE
TO_DAYS(e.writingtime)=TO_DAYS('2019-08-21')
GROUP BY
HOUR (e.writingtime)