Created Database using SQLite3 and added SQLite3.txt in Systems/SQL_Operations folder.
Technical Specifications
Code is based on SQLite3 and uses commands like create,insert,order by and others.
How to run
This code is to be executed in any SQLite service available. I have used DBBrowser for sqlite application to create this database.
DB Browser Steps:
1.Click on New Database and enter name of database.
2.Switch to ExecuteSQL tab and copy-paste this code till INSERT INTO commands only into the tab.
3.Click Execute all button or Ctrl+R.
4.The database will be created.
For performing the queries:
1.Enter the text code only one query at a time from the txt file into the Execute SQL tab and click Execute all button.
2.The Output of the Queries will be displayed on the frame below the Execute SQL tab.
Checklist
[x] Code compiles correctly.
[x] Changes are tested properly.
[x] Added the README / documentation, if necessary.
krithikvaidya
commented
4 years ago
Resolves Issue #89
Description
Created Database using SQLite3 and added SQLite3.txt in Systems/SQL_Operations folder.
Technical Specifications
Code is based on SQLite3 and uses commands like create,insert,order by and others.
How to run
This code is to be executed in any SQLite service available. I have used DBBrowser for sqlite application to create this database. DB Browser Steps: 1.Click on New Database and enter name of database. 2.Switch to ExecuteSQL tab and copy-paste this code till INSERT INTO commands only into the tab. 3.Click Execute all button or Ctrl+R. 4.The database will be created. For performing the queries: 1.Enter the text code only one query at a time from the txt file into the Execute SQL tab and click Execute all button. 2.The Output of the Queries will be displayed on the frame below the Execute SQL tab.
Checklist