下载地址
navicat
连接
创建数据库
创建数据表
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
