On Code Comment

Brian W. Kernighan and Rob Pike have some excellent suggestions for writing comments. They are said best as they appear in "The Practice of Programming," [1]:

  • Don't belabor the obvious. Comments shouldn't report self-evident information such as the fact that i++ has incremented i.

     

  • Don't comment bad code, rewrite it. Comment anything unusual or potentially confusing, but when the comment outweighs the code, the code probably needs fixing.

     

  • Don't contradict the code. Most comments agree with the code when they are written, but as bugs are fixed and the program evolves, the comments are often left in their original form, resulting in disagreement with the code. Whatever the source of disagreement, a comment that contradicts the code is confusing, and many a debugging session has been needlessly protracted because a mistaken comment was taken as truth. When you change code, make sure that the comments are still accurate. Comments should not only agree with code, they should support it.

     

  • Clarify, don't confuse. Comments are supposed to help readers over the hard parts, not create more obstacles.

     

  • When it takes more than a few words to explain what's happening, it's often an indication that code should be rewritten.

     

  • Students are taught that it's important to comment everything. Professional programmers are often required to comment all their code. But the purpose of commenting can be lost in blindly following rules. Comments are meant to help a reader understand parts of the program that are not readily understood from the code itself. As much as possible, write code that is easy to understand; the better you do this, the fewer comments you need. Good code needs fewer comments than bad code.

References

[1] Kernighan, Brian W. and Pike, Rob, The Practice of Programming, Addison Wesley, 1999, pages 23-27.

CREATE TABLE "SZ_DSJ"."FSZ_DIM_ORG_NYNCB_ACCT_INFO" ( "DAY_ID" VARCHAR(8), "PROV_CODE" VARCHAR(6), "PROV_NAME" VARCHAR(50), "CITY_CODE" VARCHAR(8), "CITY_NAME" VARCHAR(100), "COUNTY_CODE" VARCHAR(20), "COUNTY_NAME" VARCHAR(100), "TOWN_CODE" VARCHAR(20), "TOWN_NAME" VARCHAR(200), "VILLAGE_CODE" VARCHAR(50), "VILLAGE_NAME" VARCHAR(200), "ADDR" VARCHAR(500), "LVL" VARCHAR(20), "ORG_NAME" VARCHAR(200), "CREDIT_CODE" VARCHAR(20), "REMARK" VARCHAR(500), "UPDATE_DT" VARCHAR(8)) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE SZ_DSJ.FSZ_DIM_ORG_NYNCB_ACCT_INFO IS '组织信息-农业农村部-账套'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_ORG_NYNCB_ACCT_INFO."ADDR" IS '地址'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_ORG_NYNCB_ACCT_INFO."CITY_CODE" IS '市-代码'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_ORG_NYNCB_ACCT_INFO."CITY_NAME" IS '市-名称'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_ORG_NYNCB_ACCT_INFO."COUNTY_CODE" IS '区县-代码'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_ORG_NYNCB_ACCT_INFO."COUNTY_NAME" IS '区县-名称'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_ORG_NYNCB_ACCT_INFO."CREDIT_CODE" IS '唯一社会信用代码'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_ORG_NYNCB_ACCT_INFO."DAY_ID" IS '数据日期'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_ORG_NYNCB_ACCT_INFO."LVL" IS '层级'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_ORG_NYNCB_ACCT_INFO."ORG_NAME" IS '集体经济组织名称'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_ORG_NYNCB_ACCT_INFO."PROV_CODE" IS '省-代码'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_ORG_NYNCB_ACCT_INFO."PROV_NAME" IS '省-名称'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_ORG_NYNCB_ACCT_INFO."REMARK" IS '备注'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_ORG_NYNCB_ACCT_INFO."TOWN_CODE" IS '街道-代码'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_ORG_NYNCB_ACCT_INFO."TOWN_NAME" IS '街道-名称'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_ORG_NYNCB_ACCT_INFO."UPDATE_DT" IS '更新日期'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_ORG_NYNCB_ACCT_INFO."VILLAGE_CODE" IS '村-代码'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_ORG_NYNCB_ACCT_INFO."VILLAGE_NAME" IS '村-名称'; 把这一段sql语句转为mysql的建表语句
06-04
CREATE TABLE "SZ_DSJ"."FSZ_DIM_AREA_NYNCB_INFO" ( "DAY_ID" VARCHAR(8), "PROV_CODE" VARCHAR(6), "PROV_NAME" VARCHAR(50), "CITY_CODE" VARCHAR(6), "CITY_NAME" VARCHAR(100), "COUNTY_CODE" VARCHAR(10), "COUNTY_NAME" VARCHAR(100), "TOWN_CODE" VARCHAR(20), "TOWN_NAME" VARCHAR(200), "VILLAGE_CODE" VARCHAR(50), "VILLAGE_NAME" VARCHAR(200), "AREA_CODE" VARCHAR(20), "LVL" VARCHAR(1), "REMARK" VARCHAR(500), "UPDATE_DT" VARCHAR(8)) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE SZ_DSJ.FSZ_DIM_AREA_NYNCB_INFO IS '行政区划信息-农业农村部'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_AREA_NYNCB_INFO."CITY_CODE" IS '市-代码'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_AREA_NYNCB_INFO."CITY_NAME" IS '市-名称'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_AREA_NYNCB_INFO."COUNTY_CODE" IS '区县-代码'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_AREA_NYNCB_INFO."COUNTY_NAME" IS '区县-名称'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_AREA_NYNCB_INFO."DAY_ID" IS '数据日期'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_AREA_NYNCB_INFO."PROV_CODE" IS '省-代码'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_AREA_NYNCB_INFO."PROV_NAME" IS '省-名称'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_AREA_NYNCB_INFO."REMARK" IS '备注'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_AREA_NYNCB_INFO."TOWN_CODE" IS '街道-代码'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_AREA_NYNCB_INFO."TOWN_NAME" IS '街道-名称'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_AREA_NYNCB_INFO."UPDATE_DT" IS '更新日期'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_AREA_NYNCB_INFO."VILLAGE_CODE" IS '村-代码'; COMMENT ON COLUMN SZ_DSJ.FSZ_DIM_AREA_NYNCB_INFO."VILLAGE_NAME" IS '村-名称'; 帮我改为mysql建表语句,字段名改为小写
06-04
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值