this is embedded db

root

• db
• testDB
  • database.js
  • table.js
  • handler.js
  • input.js

you need change 'dbroot' value to your 'project root path\db'

example

const root = 'C:\Users\[your user name]\[your path]\db'

cd testDB
node input and input below command

1. db create [db name] => new folder

2. db use [db name] => path : db folder

3. db drop [db name] => rm folder

4. db show => print db list

5. tb create [table name] (...) => new file in db folder
   

tb create(column name, type, [primary key = no, auto_increment=no, not null = no, default = null])

6. tb insert into [table name] (col1, [col2, col3, ...]) values(vla1, [val2, val3, ...])

7. tb select [column name] from [table name] where (col name = value)

회원가입 : 이메일 주소 있는지, select email from user where email=(check_email)

8. tb update [table name] set [feild name1=data1, ...] where (feild name = value)

9. tb delete [table name] => rm file

10. tb show => print table list

11. tb desc [table name] => desc table