we can use DataGrip to write Sqls in a window. Thats wonderful.
for example:
-- desc tbl_unit;
-- select * from tbl_unit;
# 每个区(高桥区)下面的所有街道信息:
/*
select
id,
name,
manager_user,
address,
gds1
from tbl_unit
where fatherid in (select id
from tbl_unit
where del = 0 and fatherid = 2)
and state = '正常营业'
and area_id = 1;
*/
When we use it ,we can write everything. When we don't use it ,we can make an annotation by --
#
or /**/
注:代码上面的"正常营业"并不是笔者设计的,笔者后来看到这汉字,实在无法接受。