Node+Mysql2

下载地址

dev.mysql.com/downloads/m…

navicat

navicat.com.cn/download

连接

创建数据库

创建数据表

Mac上解决Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'

亲测可行：参考链接 www.bbsmax.com/A/RnJWg91rJ…

数据库增删改查

INSERT

INSERT INTO users (id,name,age) VALUES (0,?,?)

DELETE

DELETE FROM users WHERE id=?

UPDATE

UPDATE users SET age=? WHERE id=?

SELECT

SELECT * FROM users WHERE age>? ORDER BY age DESC LIMIT ?,?

条件语句

1.ADN 2 OR 3. ORDER BY (DESC/ASC) 4.LIMIT 5.LIKE 6.JOIN ON 7.AS

node 中 mysql2

报错信息

package.json里的name 与npm i mysql2 不能相同

出现莫名ip查看是否切了host