자기 개발하기

app.post("주소" , function(req,res) {

     for(var i= req.body.length; i++)

     {

//추가할 data

          req.body[i].c1 = "c5"

          req.body[i].c2 = "c4"

          req.body[i].c3 = "c3"

          req.body[i].c4 = "c2"

          req.body[i].c5 = "c1"

      }

});

db.collection.renameCollection("collectionName")

   (컬렉션이름)                      (변경할컬렉션이름)

db.collection.updateMany({_id: 1234}, {$rename : {"g1", "g2"}} )

                                    (조건)                    (변경전: 변경할값)

Sub 특정단어검색()

     Cells.Find(What : = "특정단어", After : = ActiveCell, LookIn :=xFormulas, _

     LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirectin:=xlNext, _

     MatchCase:=False, MatchByte:=False, SearchFormat:=False).Activate

Selection.EntireRow.Insert, CopyOrigin:=xlFormatFromLeftOrAbove

ActiveCell.FormulaR1C1 = "합계"

Set Rng = Range(ActiveCell.Address)

Rng.Offset(0,1).Select '//오른쪽으로이동

ActiveCell.FormulaR1C1 = "=SUM(B2:R[-1]C)" '//합계

ActiveWindow.SmallScroll Down:=-1

Cells.Replace What:="'B2'", Replacement:="B2", LookAt:=xlPart, _

      SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _

      ReplaceFormat:=False

'// B2에 "" 가붙으므로 제거

End Sub