work

1. Excel生成sql

="insert into user (user_name, pass_word, create_time) values ('"&A4&"','"&B4&"', '1', now())"

2. 设置淘宝镜像

npm config set registry https://registry.npm.taobao.org

3. pip install 安装包

pip install  bagName -i https://pypi.tuna.tsinghua.edu.cn/simple

3. pip install 安装包

pip install  bagName -i https://pypi.tuna.tsinghua.edu.cn/simple

4. mysql 默认不区分大小写

ALTER TABLE `xxx` MODIFY `short_key` CHAR(10) CHARACTER SET utf8 COLLATE utf8_bin;