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]
Pampers Active Baby Tape Style Baby Diapers, New Born/Extra Small (NB/XS) Size, 72 Count, Adjustable Fit with 5 star skin protection, Up to 5kg Diapers
₹1,009.00 (as of May 11, 2024 02:30 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.)Bumtum Chota Bheem Large Baby Diaper Pants, 62 Count, Leakage Protection Infused With Aloe Vera, Cottony Soft High Absorb Technology (Pack of 1)
₹449.00 (as of May 11, 2024 02:30 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.)Tedibar Moisturising Baby Bathing Bar 75gx2(Pack of 1) with Skin Friendly PH|100% Soap Free|Dermatologically Tested and No. 1* Pediatrician Prescribed Moisturising Bar - By Torrent Pharma
₹349.00 (as of May 11, 2024 02:30 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.)Bumtum Baby Gentle 99% Pure Water Soft Moisturizing Wet Wipes With Lid | Aloe Vera & Chamomile Extracts | Paraben & Sulfate Free (Pack of 6, 72 Pcs. Per Pack)
Now retrieving the price.
(as of May 11, 2024 02:30 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.)DS CARE Silicon Corner Protector for Sharp Edges Table Corner Protector for Baby Kids Edge Protector for Furniture Bed Baby Proofing Edge & Corner Guards by VIVNITS (12)
₹297.00 (as of May 11, 2024 02:30 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.)Luem - above the best Baby Helmet for Crawling Walking Baby Head Protector - Head Protection for Infant Baby No Bumps and Soft Cushion Safety Headguard I Toddler Inflatable Helmets (Blue)
₹199.00 (as of May 11, 2024 02:30 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.)Babycov Neem Wood Teethers for Babies | Natural and Organic | Wooden Baby Teether | Helps in Teething | for 3+ Months Babies. (1 Set Dumbell Teether)
₹179.00 (as of May 11, 2024 02:30 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.)Lifelong Potty Seat for kids 1 to 6 years - 3 in 1 Baby Potty Training Seat - Including Toilet Chair with Pot for Baby, Comfy Soft Cushioned Toilet Seat & Stepper - Non-Slip Seat for Child Safety
₹1,529.00 (as of May 11, 2024 02:30 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.)Sebamed Baby Body Lotion 400 ml|Ph 5.5|Camomile & Allantoin| Dermatalogically tested| Sensitive skin
₹1,105.00 (as of May 11, 2024 02:30 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.)Philips Avent Natural Response Baby Feeding Bottle - 2 x 125ml Baby Milk Bottle for Newborns and Up, BPA Free, 0+ Months (Model SCY900/02)
₹895.00 (as of May 11, 2024 02:30 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.)boAt Type C A750 6.5A Super Fast Charging Flat Cable Cable with Stress Resistant, Tangle-free, & 480Mbps Data Transmission, 10000+ Bends Lifespan and Extended 1.5m Length (Rebellious Black)
Now retrieving the price.
(as of May 10, 2024 17:31 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.)