Creating a database and Table by using MYSQL
🟢 MYSQL is a widely used relational database management system (RDMS). It is an open-source application.
🟢 When data is stored in rows and columns means “stored tabular data”. The data in a row is called “RECORD”. The data in a column is called “FIELD”.
💠 For creating the Shirt table in MYSQL I am using some important commands.
◼ CREATE DATABASE — creates a new database.
◼ USE — selects a simple database and then performs operations on it using the in-built commands.
◼ CREATE TABLE — creates a new table.
◼ SELECT — extracts data from a database.
◼ INSERT INTO — inserts new data into a database.
◼ WHERE — filtering records in a table.
◼ UPDATE — modify the existing records in a table.
◼ DELETE — deletes existing records in a table.
◼ DROP — drops an existing table in a database.
🔹 Column Names:
shirts_id
Article
color
shirt_size
last_worn
🔺 MANUAL DATA
(‘t-shirt’,’ white’,’s’,10),(‘t-shirt’,’ green’,’s’,200),(‘polo shirt’,’ black’,’ M’,10),(‘tank top’,’ blue’,’s’,50),(‘t-shirt’, ’pink’, ’s’,0),(‘polo shirt’,’ red’,’ M’,5),(‘tank top’, ’white’, ’s’,200),(‘tank top’, ’blue’,’ M’,15);
🟧 What all I do for creating a Table with few instructions in it.
◼ Create a new database shirt_db.
◼ Create a new table shirts1.
◼ Insert Values.
◼ Add a new shirt — purple, polo shirt, size — “M”, last worn 50 days ago.
◼ Select all shirts but only Print out Article and color.
◼ Select all Medium shirts and print out everything but shirts_id.
◼ Update all polo shirts— change their size to “L”.
◼ Update the shirts1 last worn 15 days ago — change last worn = 0.
◼ Update all-white shirts1 — change the size to “XS” and color to “off-white”.
◼ Delete all old shirts1— last worn 200 days ago.
◼ Delete all tank tops.
◼ Delete all shirts1.
◼ Drop the entire shirts1 table.
📹 In the video I have missed out one thing.
⏭ DELETE tank tops
🔻 Type DELETE FROM shirts1 WHERE Article = 'tank top'.
🔻 Cross check with SELECT * FROM shirts1; to know the tank top data is deleted or not.
#MYSQL #database #mysqlworkbench
Thanks For watching 😊😊
🔰subscribe, Like & Share✅
Check more on:
✅ Medium: / sky_higher_freak .
✅ Replit: https://replit.com/@unica
✅ Github: https://github.com/Umasri0
✅ YouTube: / @sky_higher_freak