module.exports = {
queryAll(db, limit = '') {
return 'SELECT * FROM ' + db + ' limit ' + limit
},
insertAll(db, num) {
return 'INSERT INTO ' + db + ' VALUES ("id",' + Array(num).fill('?').join() + ')'
},
delAll(db, id) {
return 'DELETE FROM ' + db + ' WHERE id=' + id
},
next(db, id, num) {
return 'select * from ' + db + 'where' + id + ' = (select max(' + id + ') from ' + db + ' where ' + id + ' < ' + num + ' )'
},
prev(db, id, num) {
return 'select * from ' + db + 'where' + id + ' = (select min(' + id + ') from ' + db + ' where ' + id + ' > ' + num + ' )'
},
insertOnly(db,num){
return 'insert ignore '+db+ ' VALUES ("id",' + Array(num).fill('?').join() + ')'
}
}
数据库名为dbname,表名table,字段名fieldname.
ALTER TABLE dbname.table ADD UNIQUE (fieldname); 查看全部

module.exports = {

  queryAll(db, limit = '') {

    return 'SELECT * FROM ' + db + ' limit ' + limit

  },

  insertAll(db, num) {

    return 'INSERT INTO ' + db + ' VALUES ("id",' + Array(num).fill('?').join() + ')'

  },

  delAll(db, id) {

    return 'DELETE FROM ' + db + ' WHERE id=' + id

  },

  next(db, id, num) {

    return 'select * from ' + db + 'where' + id + ' = (select max(' + id + ') from ' + db + ' where ' + id + ' < ' + num + ' )'

  },

  prev(db, id, num) {

    return 'select * from ' + db + 'where' + id + ' = (select min(' + id + ') from ' + db + ' where ' + id + ' > ' + num + ' )'

  },

  insertOnly(db,num){

  	return 'insert ignore '+db+ ' VALUES ("id",' + Array(num).fill('?').join() + ')'

  }

}

ALTER TABLE dbname.table ADD UNIQUE (fieldname);