thindi的博客

官方给的代码如下：load data infile '/yourfilepath/test.csv'  into table table名fields terminated by ','  optionally enclosed by '"' escaped by '"'  lines terminated by '\r\n';每一行解释如下：CSV文件存放路径要将数据导入的...

我们要爬取得网站是500w彩票网，因为他页面简单，容易分析。好，接下来就开始准备工作这就是我们要爬取得数据，可以指定期号，我准备爬14年到19年所有的首先准备导入的库import requests,os,csv,timefrom selenium import webdriverfrom lxml import etree我们还是用比较实用的requests库来爬取数据，...

1.flask 数据迁移提示INFO  [alembic.runtime.migration] Context impl MySQLImpl.INFO  [alembic.runtime.migration] Will assume non-transactional DDL.ERROR [root] Error: Can't locate revision identified by '...

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)或者ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’...

首先mysql方法，原生写法，这边以mysql8.0为例，user表有个lat_login字段，查询当天的数据select * from users where DATE(last_login) = CURDATE();再就是sqlserver的写法，同样的表，字段select * from confirmation_documents where DATEDIFF(day,las...