大良营销网站公司,立即注册,网站做适配手机要多久,项目建设全过程有哪些阶段关于node.js操作mysql数据库的相关介绍请阅读全文吧。下文介绍的非常详细#xff0c;具体内容如下所示#xff1a;安装mysql模块npm install mysql数据库准备mysql server所在的机器IP地址是192.168.0.108#xff0c;登录账户就用root123456在mysql中创建test数据库在test数…关于node.js操作mysql数据库的相关介绍请阅读全文吧。下文介绍的非常详细具体内容如下所示安装mysql模块npm install mysql数据库准备mysql server所在的机器IP地址是192.168.0.108登录账户就用root123456在mysql中创建test数据库在test数据库中创建一张users表操作连接数据库var mysqlrequire(mysql);var connection mysql.createConnection({host : 192.168.0.108,user : root,password : 123456,database : test1,port:3306});connection.connect();插入一个uservar usr{name:zhangsan,password:pwdzhangsan,mail:zhangsangmail.com};connection.query(insert into users set ?,usr,function(err,result) {if (err) throw err;console.log(inserted zhangsan);console.log(result);console.log(\n);});更新user带条件connection.query(update users set passwordddd where namezhangsan,{password:ppp},result) {if (err) throw err;console.log(updated zhangsan\s password to ddd);console.log(result);console.log(\n);});删除一个user带条件connection.query(delete from users where namezhangsan,result) {if (err) throw err;console.log(deleted zhangsan);console.log(result);console.log(\n);});查询user所有connection.query(select * from users,rows,fields) {if (err) throw err;console.log(selected after deleted);for(var i 0,usr;usrrows[i];){console.log(user naeusr.name ,passwordusr.password);}console.log(\n);});关闭数据库连接connection.end();基本的CRUD完成mysql模块的完整功能说明参见官方全部demo代码var mysqlrequire(mysql);var connection mysql.createConnection({host : 192.168.0.108,port:3306});connection.connect();var usr{name:zhangsan,result) {if (err) throw err;console.log(inserted zhangsan);console.log(result);console.log(\n);});connection.query(select * from users,fields) {if (err) throw err;console.log(selected after inserted);for(var i 0,passwordusr.password);}console.log(\n);});connection.query(update users set passwordddd where namezhangsan,result) {if (err) throw err;console.log(updated zhangsan\s password to ddd);console.log(result);console.log(\n);});connection.query(select * from users,fields) {if (err) throw err;console.log(selected after updated);for(var i 0,passwordusr.password);}console.log(\n);});connection.query(delete from users where namezhangsan,result) {if (err) throw err;console.log(deleted zhangsan);console.log(result);console.log(\n);});connection.query(select * from users,passwordusr.password);}console.log(\n);});connection.end();
