C++ & GUI: Manage SQLite Database

In this video we will create a small app to manage a basic SQLite database,

and we will play with it to do the following items:

– CREATE A TABLE
CREATE TABLE user (Name TEXT, Age INT, Country TEXT);

– INSERT DATA
INSERT INTO user (Name, Age, Country) VALUES (‘Itokiana’, 5, ‘Madagascar’);
INSERT INTO user (Name, Age, Country) VALUES (‘John’, 26, ‘USA’) ;
INSERT INTO user (Name, Age, Country) VALUES (‘Louis’, 34, ‘France’) ;
INSERT INTO user (Name, Age, Country) VALUES (‘Lee’, 22, ‘Japan’) ;
INSERT INTO user (Name, Age, Country) VALUES (‘Chris’, 19, ‘Canada’) ;
INSERT INTO user (Name, Age, Country) VALUES (‘Unknown’, 10, ‘Anywhere’) ;

– UPDATE DATA
UPDATE user SET Name=”Njaka” WHERE Name=”Itokiana”;

– DELETE DATA
DELETE FROM user WHERE Name=’Unknown’;

– SELECT DATA
SELECT * FROM user ORDER BY Name ASC;

Source code: https://drive.google.com/file/d/0B1Jtvy4Ey-uwZXRqeVFVa0xLeHM/edit?usp=sharing
Exe file: https://drive.google.com/file/d/0B1Jtvy4Ey-uwajZUUHpKczZ5bDg/edit?usp=sharing

SQLite tutos: http://www.tutorialspoint.com/sqlite/