// 查询 conn.query()// 创建表constCREATE_SQL=`CREATE TABLE IF NOT EXISTS test (
id INT NOT NULL AUTO_INCREMENT,
username VARCHAR(45) NULL,
age INT NULL,
message VARCHAR(45) NULL,
PRIMARY KEY (id))`;constINSERT_SQL=`INSERT INTO test(username,age,message) VALUES(?,?,?)`;// 使用占位符constSELECT_SQL=`SELECT * FROM test`;
conn.query(CREATE_SQL,(err, data)=>{
if(err){
throw err;}// 插入数据
conn.query(INSERT_SQL,['song','10',"hello,world"],(err, result)=>{
if(err){
throw err;}
console.log(result);
conn.