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]
R for Rabbit Protector Plus Door Stopper for Kids | Safety Certified | Prevents Finger Pinching | 180° Rotating | Strong 3M Adhesive | Scratch-Free | Baby Proofing Lock (1 Pc)
₹191.00 (as of July 6, 2025 20:53 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Techhark® Perfect Posture Bathroom Toilet Step Stool with Massage Rollers, 18 cm Height, Foldable Design, (Grey and Black)
₹398.00 (as of July 6, 2025 20:53 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Pax Parrot Baby Powder Puff Box – Bear Design | 4 Pax Parrot Characters Stickers for Baby | Refillable Dispenser with Soft Applicator for Newborns & Infants | Compact & Travel-Friendly Containr (Turquoise)
₹275.00 (as of July 6, 2025 20:53 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Mini Wonders Inflatable Water Play Mat, Baby Tummy Time Mat, Safe BPA-Free, 0-12 Months
₹179.00 (as of July 6, 2025 20:53 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
One94Store Rechargeable Silicone Panda Night Light for Kids | 7-Color LED Changing Lamp |Adorable Room Decor & Gift for Toddlers, Teens, & Valentine's Day Present|Soft BPA-Free Nightlight| Multicolour
₹370.00 (as of July 6, 2025 20:53 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Huggies Comfy Pants Baby Diaper, Large (L) Size (9-14 Kgs), Pack of 96
₹898.00 (as of July 6, 2025 20:53 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Baby Disposable Diaper Bags with Dispenser, Waste Bags 6 Refill Rolls/90 Bags, Convenient and Quick Diaper Disposal, Unscented Leak & Odors Proof Diaper Trash Bags for Newborn Diapers (6 Roll + Case)
₹279.00 (as of July 6, 2025 20:53 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Himalaya Powder For Baby, 700G
₹313.00 (as of July 6, 2025 20:53 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
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)
₹378.00 (as of July 6, 2025 20:53 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
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
₹588.00 (as of July 6, 2025 20:53 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
TP-Link AC750 Wifi Range Extender | Up to 750Mbps | Dual Band WiFi Extender, Repeater, Wifi Signal Booster, Access Point| Easy Set-Up | Extends Wifi to Smart Home & Alexa Devices (RE200)
₹2,499.00 (as of July 7, 2025 09:05 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
TP-Link TL-WA850RE Single_Band 300Mbps RJ45 Wireless Range Extender, Broadband/Wi-Fi Extender, Wi-Fi Booster/Hotspot with 1 Ethernet Port, Plug and Play, Built-in Access Point Mode, White
Now retrieving the price.
(as of July 7, 2025 09:05 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Oakter Mini UPS for 12V WiFi Router Broadband Modem | Backup Upto 4 Hours | WiFi Router UPS Power Backup During Power Cuts | UPS Broadband Modem (12 Volt Backup Upto 4 HRS)
₹1,299.00 (as of July 7, 2025 09:05 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Safari Omega spacious/large laptop backpack with Raincover, college bag, travel bag for men and women, Black, 30 Litre
₹699.00 (as of July 7, 2025 09:05 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)