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]
Zoliva Baby Feeding Pillow with Detachable Cover Breast Feeding & Nursing Pillow Newborn, Infant Support for Baby and Mom Cradle 0-24 Months Breastfeeding Bottle (Gray-Animals)
₹799.00 (as of April 28, 2024 00:10 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 Extra Moisturizing Baby Wash, 400 ml
₹189.00 (as of April 28, 2024 00:10 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 Angel Super Soft Cleansing Baby Wipes Lid Pack, 648 Count, Enriched with Aloe vera & Vitamin E, pH balanced, Dermatologically Tested & Alcohol-free, Pack of 9,72 count/pack
₹415.00 (as of April 28, 2024 00:10 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 Complete Comfort Wonder Pants Extra Large (XL) Size (12-17 Kgs) Baby Diaper Pants, 112 count| India's Fastest Absorbing Diaper with upto 4x faster absorption | Unique Dry Xpert Channel
₹1,130.00 (as of April 28, 2024 00:10 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 Bottle - 260ml Baby Milk Bottle, BPA Free for Babies 1 Month (260ml Giraffe Print)
₹629.00 (as of April 28, 2024 00:10 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.)
Supples Premium Diapers, X-Large (XL), 54 Count, 12-17 Kg, 12 hrs Absorption Baby Diaper Pants
₹525.00 (as of April 28, 2024 00:10 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.)
Mamaearth Milky Soft Mineral Based Sunscreen SPF 30 & PA+++ With Oats, Milk and Calendula for Babies-80g | Made Safe Certified | Toxin Free | Sun Protection
₹289.00 (as of April 28, 2024 00:10 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 Angel Super Soft Cleansing Baby Wipes, 864 Count, Enriched with Aloe vera & Vitamin E, pH Balanced, Dermatologically Tested & Alcohol-free, Pack of 12, 72 count/pack
₹505.00 (as of April 28, 2024 00:10 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 Feeding Pillow with Detachable Cover Breast Feeding & Nursing Pillow Newborn, Infant Support for Baby and Mom Cradle 0-24 Months Breastfeeding Bottle, Nursing Pillow (Animl Greys)
₹799.00 (as of April 28, 2024 00:10 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 April 28, 2024 00:10 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.)
Ambrane Unbreakable 60W Fast Charging 1.5M Braided Type C to Type C Cable for Smartphones, Tablets, Laptops & other Type C devices, PD Technology, 480Mbps Data Sync (RCTT15, Black)
₹199.00 (as of April 27, 2024 15:58 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.)
SanDisk Ultra Dual Drive Go USB Type C Pendrive for Mobile (Black, 128 GB, 5Y - SDDDC3-128G-I35)
₹929.00 (as of April 27, 2024 15:58 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 Rockerz 255 Max in Ear Earphones with 60H Playtime,Eq Modes,Power Magnetic Earbuds,Beast Mode,Enx Tech,ASAP Charge(10 Mins=10 Hrs),Textured Finish,Dual Pair(Stunning Black),Bluetooth
₹1,099.00 (as of April 27, 2024 15:58 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.)
HP 680 Original Ink Advantage Cartridge (Black)
₹789.00 (as of April 27, 2024 15:58 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.)