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]
Infant Toy Gift Activity Play Mat,Baby Infant Toddlers Inflatable Water Play Floor Mat Children Growth Activity Tool Baby Water Mat Toy for Baby Round Mat (63X 63X 4 Centimeters) - Multicolor
₹349.00 (as of December 20, 2024 19:08 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 Total Care Baby Pants Diapers, XL 74 Count, Anti-Rash Shield, 12-17 kg, Rapid Absorption, Superior Comfort, Clinically tested
₹1,550.00 (as of December 20, 2024 19:08 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.)
Terviiix Double Sided Water Proof Baby Play Mat, Play Mats for Kids Large Size, Baby Carpet, Play Mat Crawling Baby Baby Play Mat, Non-Slip (6x4 ft, 0.3cm Thickness)(Green)
₹449.00 (as of December 20, 2024 19:08 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.)
MamyPoko Pants Extra Absorb Baby Diapers, Large (L), 64 Count, 9-14kg
₹867.00 (as of December 20, 2024 19:08 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.)
AEREX Premium Reusable Baby Cloth Diapers For 0 to 3 Years With White Insert Pads | Leak Proof Washable Diapers For New Born Babies | Adjustable Pocket Cloth Diaper Nappies (Multicolor, Pack of 4)
₹469.00 (as of December 20, 2024 19:08 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.)
LuvLap Moisturising Wet Wipes with Lid For Baby Skin, Enriched with Aloe Vera, Vitamin E & Chamomile Extract, pH Balanced, Dermatologically Safe, Paraben & Sulphate Free, 72 Wipes, pack of 3
₹207.00 (as of December 20, 2024 19:08 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.)
MamyPoko Pants All Night Absorb Baby Diapers, Large (L), 44 Count 9-14 kg
₹416.00 (as of December 20, 2024 19:08 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.)
TEDDYY Baby Easy Pant Diapers Extra Large 54 Count (Pack of 1), 12-17 kgs, 12 hrs Leak Protection, Anti - Bacterial
₹689.00 (as of December 20, 2024 19:08 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.)
R for Rabbit Large L Size Premium Feather Diaper for Baby 9 to 14 kgs (24 Pack Offer)
₹476.00 (as of December 20, 2024 19:08 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.)
CERELAC Baby Cereal | No Refined Sugar | Wheat Apple for 6-24 months baby | Omega 3 Iron Protein Calcium for babies | Instant infant Cereal | Travel Friendly | 350g
₹295.00 (as of December 20, 2024 19:08 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.)
HUMBLE® Spiral Charger Cable Protector Data Cable Saver Charging Cord Protective Cable Cover (25 Pieces)
₹99.00 (as of December 21, 2024 05:17 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.)
Dyazo Water Resistant Laptop Sleeve with Handle Compatible for 15 Inch to 15.6" Inches laptops & Notebooks - Grey
₹299.00 (as of December 21, 2024 05:17 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.)
Mi Xiaomi 33W Fast Charging Cable USB C Quick Charge 4.0 Soniccharge Cord Compatible withMi, Redmi, iPhone 15 Pro Samsung Galaxy Android Phone Laptop PD Charger Cable (White)
₹219.00 (as of December 21, 2024 05:17 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.)
Logitech M186 Wireless Mouse, 2.4GHz with USB Mini Receiver, 12-Month Battery Life, 1000 DPI Optical Tracking, Ambidextrous, Compatible with PC, Mac, Laptop
₹495.00 (as of December 21, 2024 05:17 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.)