MySQL

What is MYSQL?

MySQL, pronounced either “My S-Q-L” or “My Sequel”.

MYSQL is an open source relational database management system.

MYSQL is based on the structure query language (SQL), which is used for adding, removing, and modifying information in the database. Standard SQL commands, such as ADD, DROP, INSERT, and UPDATE can be used with MySQL.

Importance of MYSQL?

MYSQL Database server provides the ultimate in scalability, supporting the capacity to handle deeply embedded applications with a footprint of only 1MB to running massive data warehouses holding terabytes of information.
Platform Compatability is the best feature of MySQL that it supports all flavors of Linux, UNIX, and Windows being.
The open source nature of MySQL allows complete customization for those wanting to add unique requirements to the database server.
A unique storage-engine architecture that allows to configure the MySQL database server specifically for particular applications, with the end result being amazing performance results.
MYSQL features include complete ACID (atomic, consistent, isolated, durable) transaction support.
MySQL is not a typical open source project as all the software is owned and supported by Oracle, and because of this, a unique cost and support model are available that provides a unique combination of open source freedom and trusted software with support.

History of MYSQL

Designed by MySQL AB
First appeared: 23 May 1995
Developer :Oracle Corporation
Current version : 5.7.17
URL : www.mysql.com

Examples:

To create a database in MYSQL:

Syntax: CREATE DATABASE <dbname>;

To create a table:

Syntax: CREATE TABLE <table_name> (column_name column_type);

To delete a table:

Syntax: DROP TABLE < table_name> ;

Insert values into table:

Syntax: INSERT INTO <table_name> ( field1, field2,…fieldN )
VALUES
( value1, value2,…valueN );

To fetch data from MySQL table:

Syntax: SELECT * FROM <table_name>; //returns all the fields.

Firing a condition on data of MYSQL table:

Syntax: SELECT * FROM <table_name> WHERE <condition>

To Update a value in MYSQL table:

Syntax: UPDATE <table_name> SET field=new-value
[WHERE Clause]

To delete data from a MYSQL table:

DELETE FROM < table_name> [WHERE Clause]

Pure Aura Baby Sunscreen 50 gm | SPF 30 Kids Sunscreen | 100% Mineral & Ayurvedic | Chemical-Free | Outdoor Safe | Sensitive Skin Friendly | Doctors Recommended | 6M to 8 Yrs

₹491.00 (as of June 21, 2026 23:33 GMT +05:30 - )

One94Store Astronaut Galaxy Projector Night Light – 360° Rotating Nebula Star Projector with Remote Control, Timer & Adjustable Head – Space Lamp for Kids’ Bedroom, Gifts, Gaming Room, Home & Décor

₹699.00 (as of June 21, 2026 23:33 GMT +05:30 - )

Oudain 1-Meter Edge Protector, Baby Proofing Edge Protector Strip for Baby, Child Proof Table Edge Protectors Guards Safety Bumper Cover for Furniture Desk Crib Gate Bed Wall Soft Silicone

₹99.00 (as of June 21, 2026 23:33 GMT +05:30 - )

Huggies Complete Comfort Wonder Pants | Pant Style Baby Diapers Extra Large Size (XL), 56 Count | India's Fastest Absorbing Diaper, Prevents Diaper Rash, Ideal for 12 to 17 Kgs

₹621.00 (as of June 21, 2026 23:33 GMT +05:30 - )

4-in-1 Adjustable Baby Carry Bag with Front & Back Carry Options | Ergonomic Infant to Toddler Carrier with Head and Back Support, Safety Buckles & Breathable Fabric (0–3 Years) (Navy Blue)

₹599.00 (as of June 21, 2026 23:33 GMT +05:30 - )

ZOZO SALES Infant Head Support Pillow for Newborn | Baby Neck Support Pillow Plush Baby Head Protection Cushion for 0-12 Months, Pack of 2 (Light Pink)

₹319.00 (as of June 21, 2026 23:33 GMT +05:30 - )

Himalaya Gentle Baby Powder 400g | Keeps baby's skin smooth & dry with natural goodness | Olive Oil, Almond Oil & Yashad Bhasma | No.1 Baby Powder Brand | No.1 Dr. Recommended | 99% NOI

₹209.00 (as of June 21, 2026 23:33 GMT +05:30 - )

First Kick Baby Swaddle Wrap for New Born || Adjustable Swaddle for New Born Baby || 100% Cotton Soft Baby Blanket for 0-6 Months - Pack of 1 (Multi-Color, 200 GSM)

Now retrieving the price.

(as of June 21, 2026 23:33 GMT +05:30 - )

StarAndDaisy Kids Bear Wardrobe/Multifunctional Collapsible Plastic Wardrobe/Almirah for Baby/Kids- Storage Cabinet – Dustproof Organizer for Baby Clothes, Toys & Books with Wheels & Hangers- Beige

₹5,899.00 (as of June 21, 2026 23:33 GMT +05:30 - )

Mother Sparsh 99% Pure Water (Unscented) Baby Wipes with Lid I Natural Plant made cloth - Super thick Wet Wipes I 72 pcs/pack - Pack of 2 (Super Saver Pack)

₹380.00 (as of June 21, 2026 23:33 GMT +05:30 - )

Ambrane Unbreakable 3A Fast Charging 1.5m Braided Type C Cable for Smartphones, Tablets & other Type C devices, 480Mbps Data Sync, Quick Charge 3.0 (RCT15A, Black)

₹179.00 (as of June 21, 2026 23:05 GMT +05:30 - )

Portronics Bubble 3.0 Wireless Keyboard with Bluetooth + 2.4 GHz USB Receiver, Rechargeable Battery, Dual Height Adjustment, Multimedia Hotkeys with Numpad, for Laptop, PC, Smartphone, Tablet(Black)

₹999.00 (as of June 21, 2026 23:05 GMT +05:30 - )

Gesto Portable Fan Rechargeable with LED Light – Foldable Mini Fan, Small Fan,USB Charging Hand Fan with 1200mAh Battery & 3 Speed Modes | Travel, Makeup, Kitchen,Women’s Personal Pankhaa - Grey

₹440.00 (as of June 21, 2026 23:05 GMT +05:30 - )

Etekcity Study Table Bed Table Premium Laptop Table/Foldable and Portable Wooden/Writing Desk for Office/Home/School 59cm, 40cm (C Black)

₹299.00 (as of June 21, 2026 23:05 GMT +05:30 - )

SANDISK Ultra Dual Drive Go Type-C 128GB, OTG, Upto 400MB/s, Pendrive, Black, 5Y Warranty (SDDDC3-128G-I46PD)

₹1,969.00 (as of June 21, 2026 23:05 GMT +05:30 - )