In this post you will make an SQL database.
If you have not done so already, you need to install an SQL database tool. See picture below.
SQLite Browser reads and writes a special type of file that is optimized for rapid retrieval, and storage of data.
Run SQLite Browser and create a new database. Once complete, your screen should display the following:
Now, go ahead and create a table. Use the following command on the right side of the picture shown below (assume case sensitivity). This specifies a new table called “Users”, with two columns, and up to 128 length variable characters. This code also forms a contract with the table. A contract with what is allowed, and not allowed. Put this command in the execute SQL window.
It is up to you regarding the terms of the contract, but you need to plan it ahead of time.
Next, add data (“records”) in your table as shown below.
You can even view the SQL Log to view the code every time you add a new record.
Now, you can learn for SQL commands to insert, delete, and retrieve data.
You put the SQL commands in the Execute SQL window.
At any time you can hit the “Browse Data” button to see all your records.
Following is how you delete a row.
This will delete all rows that have the matching email address.
The update statement allows you to find certain records and change their values.
Finally, you can do a retrieval with the statement shown below.
The “SELECT *” command translate to “Select All”.
You can also sort your records.
Below is a summary of all the SQL commands you have learned in this post.
This covers the basics of SQL databases. The real power will come later when you learn to exploit connections between tables.