02 2020 档案
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
摘要：node 连接数据库时报的错误。 mysql8.0以上加密方式，Node还不支持。 mysql> alter user 'root'@'localhost' identified with mysql_native_password by '1234';mysql> flush privileges
sqlServer not in 分页
摘要：select top 10 * from GoodsTab WHERE GoodsID NOT IN ( SELECT TOP (10*(2-1) GoodsID FROM dbo.GoodsTab WHERE GoodsTypeID=2 ORDER BY GoodsID DESC ) AND Go
