[Sqlite3] Sqlite Introduction

Check whether you have sqlite3 installed:

sqlite3 -version

 

To create a new db:

sqlite3 <filename.db>

 

CREATE TABLE
  bike
   (
        id BIGINT NOT NULL,
        contact BOOLEAN NOT NULL,
        email VARCHAR,
        name VARCHAR,
        phone VARCHAR,
        purchase_date DATETIME,
        purchase_price NUMERIC,
        serial_number VARCHAR
        PRIMARY KEY (id)
  )

 

Quit the editing mode:

.quit