随笔分类 - 数据库
摘要：BEGIN DECLARE no_more_record INT DEFAULT 0; DECLARE work_num INT DEFAULT 0; DECLARE work_id BIGINT(20); DECLARE work_cursor CURSOR FOR SELECT id FROM
阅读全文
摘要：delete from custom_review_record where id in ( select t.id from (select min(id) as id, COUNT(reportId) as num from custom_review_record where nodeId =
阅读全文
摘要：报错：db.collection.find({}, { "record" : 0 , "index.teacher_base_name" : 1 , "_id" : 0}) queryObject.fields().exclude("_id"); queryObject.fields().exclu
阅读全文
摘要：window安装 略 Linux安装 下载解压 # 下载 wget https://fastdl.mongodb.org/linux/mongodb-linux-x86_64-ubuntu1604-4.2.8.tgz # 解压 tar -zxvf mongodb-linux-x86_64-ubunt
阅读全文
摘要：创建（insert） 语法结构： db.collection.insert( <document or array of documents>, { writeConcern: <document>, ordered: <boolean> } ) document ：插入集合中的文档。 writeC
阅读全文
