Продолжение 常用操作 Демо
链接
var secutize = require ('squelize'); var secutize = new Squareelize ('nodejs', 'root', '', {host: '127.0.0.1', порт: '3306', диалект: 'mysql'});查询
Task.findall ({Limit: 10, Age: {gt: 3}, порядка: 'id asc'}, {raw: true, logging: true, plain: false}). On ('успех', function (res) {console.log (res);}).统计
Task.count ({where: {title: 'test_title_1'}}, {журнал: false}).最大或最小
Task.max ('id'). On ('success', function (max) {console.log (max);}). On ('affic', function (err) {console.log (err);});插入
Task.build ({title: 'test_title_3', 'description': 'test_description_3'}). Save (). On ('успех', function (msg) {console.log (msg);}). 'test_description_4'}). On ('success', function (msg) {console.log (msg);}). On ('affic', function (err) {console.log (err);});修改
Task.update ({description: 'test_description_2000'}, {id: '2'}). On ('success', function (msg) {console.log (msg);}). On ('whifle', function (err) {console.log (err);});删除
Task.destroy ({id: '4'}). On ('success', function (msg) {console.log (msg);}). On ('aff', function (err) {console.log (err);});感谢阅读 ， 希望能帮助到大家 谢谢大家对本站的支持！