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]

Himalaya Baby Lotion with Almond and Olive Oil, 400ml

₹178.00 (as of October 21, 2025 11:42 GMT +05:30 - )

Novo Baby Silicon Corner Protector for Sharp Edges – Baby Proofing Edge Guards for Tables, and Furniture. Corner Protector for Baby Safety, Designed to Protect Little One (Transparent, Pack of 12)

₹237.00 (as of October 21, 2025 11:42 GMT +05:30 - )

MamyPoko Pants Extra Absorb Baby Diapers, Large (L size) | 9-14 kg | 64 Count |Deep Sleep Diapers| Soft gentle fit |Deep Absorbent Crisscross | skin friendly with coconut oil |

₹783.00 (as of October 21, 2025 11:42 GMT +05:30 - )

StuffNest Newborn Baby Pillow with Slide Support | Adjustable Soft & Comfortable Sleep Pillow (0-12 Months) (Royal-Blue)

Now retrieving the price.

(as of October 21, 2025 11:42 GMT +05:30 - )

Mother Sparsh Natural Mosquito Repellent Fabric Roll-on for Babies-12ml, DEET Free 3-Way Protection from Mosquitoes, Fleas and Ants

₹82.00 (as of October 21, 2025 11:42 GMT +05:30 - )

Little's Soft Cleansing Baby Wipes with Lid | 80 Wipes x Pack of 3 - 240 Wipes | Extra Thick & Moist Wet Wipes for Baby's | Prevents Rashes & Redness with Goodness of Aloe Vera, Vitamin E & Jojoba Oil

₹189.00 (as of October 21, 2025 11:42 GMT +05:30 - )

Little's Premium Baby Diapers XL Size (Extra Large) Pants Style | 12-17 kg | 54 Count - Pack of 1 | Super Jumbo Baby Diaper with Leakage Guard, Wetness Indicator & 12 Hours Absorption

₹529.00 (as of October 21, 2025 11:42 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)

₹369.00 (as of October 21, 2025 11:42 GMT +05:30 - )

ANNA CREATIONS Baby Headbands – Soft Flower & Bow Shape Hair Bands for Baby Girls & Boys – Comfortable Elastic Patti Hair Accessories for Infants, Newborns & Toddlers Pack of 3 Pcs

Now retrieving the price.

(as of October 21, 2025 11:42 GMT +05:30 - )

TEDDYY Baby Easy Pant Diapers Medium 74 Count (Pack of 1), 7-12 kgs, 10 hrs Leak Protection, Anti - Bacterial

₹528.00 (as of October 21, 2025 11:42 GMT +05:30 - )

Portronics Konnect X USB to Type C Cable with 3A Output, Fast Charging & Data Transfer, Nylon Braided, Aluminium Alloy Shell, 1M Length compatible with Type C Smartphones(White)

₹125.00 (as of October 20, 2025 21:04 GMT +05:30 - )

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

₹1,049.00 (as of October 20, 2025 21:04 GMT +05:30 - )

Arctic Fox Pureview Transparent Wireless and Bluetooth Rechargeable Mouse, USB Receiver,LED Battery Magic Silm for Office/PC/Mac/Laptop/Apple/ipad(Space Gray)

₹549.00 (as of October 20, 2025 21:04 GMT +05:30 - )

Portronics Konnect L POR-1403 Fast Charging 3A Type-C Cable 1.2 Meter with Charge & Sync Function for All Type-C Devices (White)

₹109.00 (as of October 20, 2025 21:04 GMT +05:30 - )

HP 15, 13th Gen Intel Core i3-1315U (12GB DDR4, 512GB SSD) FHD, Anti-Glare, Micro-Edge, 15.6''/39.6cm, Win11, M365 Basic(1yr)* Office24, Silver, 1.59kg, fd0573TU, FHD Camera w/Shutter Laptop

₹35,490.00 (as of October 20, 2025 21:04 GMT +05:30 - )