10.6 Notes

9.25-10.6 Learning Notes

by Huang Yongjin

mysql basic grammar

• drop & create table
• select insert update
• if where from
• https://www.liaoxuefeng.com/wiki/1177760294764384
  https://www.runoob.com/sql/sql-intro.html

reading nodejs program

• input & output
• callback
• function
• require
• exports
• nodejs+sql
  • connection & pool
• https://www.runoob.com/nodejs/nodejs-install-setup.html
  https://www.runoob.com/w3cnote/nodejs-callback-func.html
  http://javascript.ruanyifeng.com/nodejs/basic.html#toc3
  https://gywbd.github.io/posts/2014/11/using-exports-nodejs-interface-design-pattern.html

Faker(a python package)

• fake.profile()
• https://zhuanlan.zhihu.com/p/37173611
  https://faker.readthedocs.io/en/master/locales/zh_CN.html

python make data

• file input & output

python + mysql

• cursor.execute()
• generate_person_address.py by Guochao Xie