MySQL CURD operations Webserver
This is basic Create Update Read and Delete operations example with a webserver.
Here we use a sample Data base structure as follows:
CREATE TABLE customer_trial (
cID int NOT NULL AUTO_INCREMENT PRIMARY KEY,
cName text NOT NULL,
cPoints int NOT NULL
)
We are creating a simple tabled called customer_trial
where
- Customer ID
cID
is the Primary key and Auto generated
- Customer Name
cName
is a string field
- Customer Points
cPoints
stores the number of points they have earned
The webserver in this project is to provide a way to do the following actions with this table:
- Open / Create the Table (
customer_trial
) from the Database
- Add Records to the Table
- Read All records from the Table
- Find Specific records in the table
- Update / modify records already in the table
- Delete records from the table
- Delete the table itself
Attribution & Thanks
The main goal of the project was to test my Knowhow and Learning
from Todd Mcleod's (@GoesToEleven) Courses:
- Learn How to Code : Google's Go pogramming language
This Couse is also available Free after Sign Up @ GreaterCommons: https://greatercommons.com/cwg
- HTML & CSS Course on Udemy
This is a Great Course and worth every penny. Its more of a investment in yourself than a course.
- Golang Web Dev Course on Udemy
I have only finished till around Section 12 as of (28th March 2018) about Relational Databases.
Hope to finish the complete course and build some thing useful.