MongoDB tutorial

MongoDB is a cross-platform, document oriented database that provides. Database Database is a physical container for collections. (DB는 co...

MySQL vs MongoDB. What is MongboDB?

What is MySQL? As one of relational system (RDBMS), MySQL stores data in tables and uses structured query language (SQL) for DB access. (S...

Install MongoDB

(1) https://www.mongodb.com/download-center#community download MongoDB (2) once installation is completed, create the path C:\data\db ...

Oracle SQL

-- replace all values of a column to certain value update DBname.TableName set folderID = replace(columnName, 'old-word', 'new...

MSSQL

-- 전체 테이블에서 특정 단어를 포함하는 이름의 컬럼 찾기 SELECT COLUMN_NAME, TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%shop_id%...