SQL&快捷键_sql中的缩进快捷键

01、IDEA快捷键

• 当你开口说话的时候，你说的话必须比你的沉默更有价值才行，否则闭嘴！
• 无序列表实心圆与空心圆问题 Ctrl +Shift+] 可打出实心圆 Enter换行或者再敲一个实心圆后按下Tab(缩进)键会变成空心圆
• 解决start.spring.io不能访问 使用阿里云链接替代 阿里云https://start.aliyun.com/ 地址直接替代
• Ctrl+R：查找并替换
• Ctrl+D：复制整行
• Ctrl+B：提示该方法中需要哪些参数
• Ctrl+Alt：同时按住点击鼠标查看实现类
• Ctrl+H：查看接口的实现类，类的继承关系
• Ctrl+Alt+T：try catch捕获异常
• Alt：同时复制多行
• iter：加强for循环
• Ctrl+Shift+N：搜索 find in path
  

02、vscode快捷键

• 查看webpack或xxx版本命令：npm view webpack或xxx versions

03、SQL语句

SELECT
	* 
FROM
	t_user_position 
WHERE
	id = 160 
SELECT
	doc.*,p.position
FROM
	t_user_position up
	LEFT JOIN t_disinfect_operate_comment doc ON up.id = doc.user_position_id
	LEFT JOIN t_position p ON up.position_id=p.position_id
	
SELECT
	doc.*,
	p.position 
FROM
	t_disinfect_operate_comment doc
	LEFT JOIN t_user_position up ON doc.user_position_id = up.id
	LEFT JOIN t_position p ON up.position_id = p.position_id
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

2022年6月24日 晓欣
SELECT * FROM `t_disinfect_object`;

select * from t_position t  where id = '32' ;

select count(1) from t_position t ;

select * from t_disinfect_object t where t.postion_id = 32

update t_disinfect_object t set t.postion_id = 32 where id in (52,69,70,71,72,73,74);

select * from t_disinfect_object t where t.id in (52,69,70,71,72,73,74);

SELECT
	doc.*,
	p.position 
FROM
	t_disinfect_operate_comment doc
	LEFT JOIN t_user_position up ON doc.user_position_id = up.id
	LEFT JOIN t_position p ON up.position_id = p.position_id
WHERE up.id = 2986
	
SELECT doc.*, p.position_id, p.position FROM t_disinfect_operate_comment doc LEFT JOIN t_user_position up ON doc.user_position_id = up.id AND up.is_delete = 0 LEFT JOIN t_position p ON up.position_id = p.position_id AND p.is_delete = 0 WHERE doc.is_delete = 0 ORDER BY up.id desc LIMIT 0 , 10

SELECT * FROM t_user_position WHERE id = 2986

------------------------------
select * from t_position t  where id = '32' ;

select count(1) from t_position t ;

select * from t_disinfect_object t where t.id in (select disinfect_object_ids from t_position where id = '32');

update t_disinfect_object set position_id = 32 where id in  (52,69,70,71,72,73,74)

select * from t_disinfect_object t where t.id in (52,69,70,71,72,73,74)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

SELECT
	m.*,
	m.id AS m_id,
	m.user_id AS m_user_id,
	m.user_position_id AS m_user_position_id,
	m.photo,
	m.comment_time AS m_comment_time,
	m.disinfectant_component,
	m.is_tostandard_disinfect,
	m.is_nowdate_disinfect,
	m.is_paste_label,
	m.create_user AS m_create_user,
	m.remark AS m_remark,
	p.position_id,
	p.position 
FROM
	t_disinfectant_match_comment m
	LEFT JOIN t_user_position up ON m.user_position_id = up.id 
	AND up.is_delete = 0
	LEFT JOIN t_position p ON up.position_id = p.position_id 
	AND p.is_delete = 0 
WHERE
	m.is_delete = 0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23