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]

DOCAT Baby Diaper Bag, Cute Felt Diaper Caddy Organizer with Removable Shoulder Strap, Baby Basket Essentials for All Newborn Baby Products Nursery Basket (Beige)

₹999.00 (as of February 6, 2026 03:53 GMT +05:30 - )

Portable Warmer Bottle,Travel-Friendly,Fast-Heating,Cordless And Rechargable,Precise Temperature Control,Long-Lasting Warming UP to 5Hour,Comfortable Feeding Bottle For Home And Outdoor(bottle not included) (A-1)

₹1,499.00 (as of February 6, 2026 03:53 GMT +05:30 - )

SWIREUK Soft Hypoallergenic Head & Neck Support Pillow, Cotton Breathable Shaping Pillow for Small Boys and Girls, Baby Pillows for Sleeping, Machine Washable, Adjustable, New Born Head Shaping

₹1,499.00 (as of February 6, 2026 03:53 GMT +05:30 - )

Baby Feeding Combo Set | 4 in 1 Baby's Feeder Bottle, Food Feeder, | Newborn Baby Essentials Kit | BPA Free, Safe & Easy to Clean (4-in-1 Baby Feeding Set with Steel Bottle, Spoon Feeder & Fruit Nibbler) (blue)

₹290.00 (as of February 6, 2026 03:53 GMT +05:30 - )

Himalaya Baby Powder 100g | No.1 Doctor-Prescribed Brand | With Yashad Bhasma & Vetiver | Sweat-Free & Refreshing Comfort | Safe for Newborns

Now retrieving the price.

(as of February 6, 2026 03:53 GMT +05:30 - )

Mylo Baby AirPrime Premium Diaper Pants Large (L) Size (9–14 kgs) (24 Count) Leak Proof | Ultra-Thin & Breathable | Up to 12 Hours Protection | No Rashes

₹499.00 (as of February 6, 2026 03:53 GMT +05:30 - )

USSBH Modern Automatic Breast Pump Efficient Electric Milk Pump for Breastfeeding Mothers Comfortable, Portable, Quiet Suction Pump Ideal Postpartum Nursing Solution

₹1,229.00 (as of February 6, 2026 03:53 GMT +05:30 - )

YOGIMOONI Nasal Aspirator, Snot Aspirator for Children, Automatic Snot Sucking with 3 Suction Levels and 3 Silicone Tips USB Charging Music Soothing Function and Seven Colour Lights

₹1,999.00 (as of February 6, 2026 03:53 GMT +05:30 - )

Himalaya Gentle Baby Wash (400ml)

₹180.00 (as of February 6, 2026 02:51 GMT +05:30 - )

Mee Mee Baby Liquid Detergent 1 L | Ph balanced, Free from Harsh Chemicals, Safe for mother's hands & baby's skin | Anti-Bacterial, Removes Stains & Odor with One Drop, Hypoallergenic

₹233.00 (as of February 6, 2026 02:51 GMT +05:30 - )

Wayona Type C to Type C 6FT/2M 65W Long Fast Charging Cable Compatible with iPhone 17, Air, iPhone 16,15 Pro/Max Series Macbook Air/Pro Samsung Galaxy S25, Ultra/S24/ S23 Flip Fold OnePlus (2M, Grey)

₹314.00 (as of February 6, 2026 10:14 GMT +05:30 - )

Dyazo Water Resistant Laptop Sleeve/Laptop case/laptop cover with Handle Compatible for 15 Inch to 15.6" Inches laptops & Notebooks - Grey

₹298.00 (as of February 6, 2026 10:14 GMT +05:30 - )

Dyazo 6 Angles Adjustable Aluminum Ergonomic Foldable Portable Tabletop Laptop/Desktop Riser Stand Holder Compatible for MacBook, HP, Dell, Lenovo & All Other Notebook (Silver)

₹348.00 (as of February 6, 2026 10:14 GMT +05:30 - )

STRIFF World Map Extended Size (800 mm x 300 mm x 2 mm) Gaming Mouse Pad| Desk Mat | Stitched Edges| Non-Slip Rubber Base|Computer Laptop|Keyboard Mouse Pad for Office & Home (World Map)

₹229.00 (as of February 6, 2026 10:14 GMT +05:30 - )

SanDisk Ultra Dual Drive Go Type-C 128GB, OTG, Upto 400MB/S,usb3.2_gen_1 Pendrive, Black, 5Y Warranty (SDDDC3-128G-I46PD)

₹1,680.00 (as of February 6, 2026 10:14 GMT +05:30 - )