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]

Mother Sparsh Natural Care Baby Body Lotion-400ml | Baby Lotion For All Skin Types | With Organic Shea Butter, Coconut Oil & Avocado | Suitable for Newborn Sensitive Skin

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

Amazon Brand - Supples Premium Baby Diaper Pants | 62 Baby Diapers | Large | 9-14 Kg | 12 Hrs Absorption | Cushiony Cotton Soft Fabric | Phthalates-Free | Triple Leak Guard

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

BRONTIX S1 Wearable Breast Pump Electrical | Hands Free Electric Breastfeeding Pump | 4 Modes & 9 Speed Levels | Electric Breast Pump for Feeding Mothers | Automatic

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

Mamypoko Pants All Night Absorb| Pant Style Baby Diapers Medium Size(M), 72 Count, Ideal for 7-12Kgs|+50% Wider and Repeated Absorption for All Night 12hr Protection from Leakage, Prevents Heaviness.

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

Amazon Brand - Supples Baby Swing for Kids | Non-Toxic Plastic | Indoor & Outdoor Use | Adjustable Design with Safety Belt | Age 6 Months to 4 Years | Green & Grey

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

Cetaphil Baby Daily Lotion, Suitable for baby’s delicate skin, Shea Butter and Vit E, Dermatologist Tested and Pediatrician Recommended, 400 ml

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

Himalaya Baby Shampoo (400ml) + Baby Powder (700g) - Combo Set| No.1 Doctor Recommended Brand

Now retrieving the price.

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

Amazon Brand - Supples Premium Baby Diaper Pants | 54 Baby Diapers | XL | 12-17 Kg | 12 Hrs Absorption | Cushiony Cotton Soft Fabric | Phthalates-Free | Triple Leak Guard

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

LuvLap Pant Style Baby Diapers, X-Large (XL), 54 Count, For babies of Upto 12-17Kg with Aloe Vera Lotion for rash protection, with upto 12hr protection, Diapers

₹533.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 - )

ProElite Smart Case for iPad (A16) 11th/10th Generation (2025/2022) [Auto Sleep/Wake Cover] [Pencil Holder] [Soft Flexible Case] Recoil Series for Apple iPad 10th/11th Gen - Dark Blue

₹399.00 (as of October 21, 2025 21:15 GMT +05:30 - )

Lenovo Idea Tab Smartchoice | Wi-Fi + 5G |11" Display, 2.5K Resolution, 90Hz Refresh|8GB RAM, 256GB ROM| MediaTek Dimensity 6300| 7040mAh|4 Speakers| USB-C| Luna Grey

₹16,990.00 (as of October 21, 2025 21:15 GMT +05:30 - )

Safari Omega spacious/large laptop backpack with Raincover, college bag, travel bag for men and women, Black, 30 Litre

₹779.00 (as of October 21, 2025 21:15 GMT +05:30 - )

Portronics Konnect X 60W Unbreakable Nylon Braided Cable, 2M Fast Charging Cable For iPhone 15 Series, iPad, Samsung Galaxy (Black)

Now retrieving the price.

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

ZEBRONICS Blanc Slim Wireless Mouse with Rechargeable Battery, BT + 2.4GHz, 4 Buttons, 800/1200/1600 DPI, Silent Operation, Multicolor LED Lights

₹399.00 (as of October 21, 2025 21:15 GMT +05:30 - )