08 SQLite Create, Read Operations
SQLite Download Page:
https://sqlite.org/download.html
-------------------------------------------------------------------
Create Database
sqlite3 Nec.db
----------------------
Create Table
create table student(studentID integer, name varchar(50), roll varchar(2), age integer);
----------------------------------
Insert Student:
Insert into Student values(1, 'Ashish', 'ELX-422', 22):
------------------------------
to get data:
(all Column, all row)
select * from student;
-----------------------
certain column , all row:
select fullname, age from student;
------------------------------------
certain column, certain row:
select fullname, age from student where condition;
On this page of the site you can watch the video online 08 SQLite Create, Read Operations with a duration of hours minute second in good quality, which was uploaded by the user Yogendra Tamang 11 September 2017, share the link with friends and acquaintances, this video has already been watched 112 times on youtube and it was liked by 2 viewers. Enjoy your viewing!
