Notes

SQLite - Create person database and insert data

author: Paul Kim

categories: sqlite

tags: sqlite

Create person database and insert data

sqlite3 person.db
create table person (id int primary key, firstname varchar(20), lastname varchar(20));

insert into person values(101, 'Danny', 'Young');
insert into person values(102, 'Christine', 'Holand');
insert into person values(103, 'Lars', 'Gordon');
insert into person values(104, 'Roberto', 'Robitaille');
insert into person values(105, 'Maria', 'Papadopoulos');

.exit

ChromeEdgeFirefoxOpera

© 2021 paulkode.com. All rights reserved.