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]

LuvLap Moisturising Wipes with Aloe Vera Lid (72 Wipes/Pack, Pack of 3)

₹159.00 (as of April 3, 2025 02:52 GMT +05:30 - )

Little's Baby Diapers L Size (Large) Pants Style | 9-14 kg | 120 Count - Pack of 4 | Cotton Soft Baby Diaper Pants with Leakage Guard

(73)

Now retrieving the price.

(as of April 3, 2025 02:52 GMT +05:30 - )

Mother Sparsh Natural Care Baby Wet Wipes with Lid | 100% Plant Made Fabric From Forest Land | Fresh+Cleanse (with Cucumber) Plant Powered Wet Wipes For Baby I Cotton Cloth Like Bigger Sheets | 60 Pcs (Pack of 3)

₹249.00 (as of April 3, 2025 02:52 GMT +05:30 - )

TONY STARK 3 Piece Baby Hair Brush & Comb Set, Wooden Baby Hair Comb Set for Newborn Babies, Natural Fiber Hair Brush for Toddlers with Soft Bristles with Pouch

₹474.00 (as of April 3, 2025 02:52 GMT +05:30 - )

PROMOM Baby Bottle Warmer | 10-in-1 Fast Baby Food Heater&Thaw BPA-Free Milk Warmer with IMD LED Display Accurate Temperature Control for Breastmilk or Formula for Bottles

(13)

₹2,249.00 (as of April 3, 2025 02:52 GMT +05:30 - )

Cherryland Baby Nail Trimmer Electric Nail Drill, Safe Baby Nail File,Baby Nail Clippers with Light &6 Grinding Pads Polishing Shape Tools for Newborn Toddler or Adults Toes and Fingernails, Kids Nail Care, Polish Trim

(24)

₹299.00 (as of April 3, 2025 02:52 GMT +05:30 - )

MamyPoko Pants Extra Absorb Baby Diapers, Large (L), 128 Count, 9-14 kg

₹1,608.00 (as of April 3, 2025 02:52 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

₹495.00 (as of April 3, 2025 02:52 GMT +05:30 - )

GITGRNTH Rechargeable Silicone Cat Night Light for Kids | Kawaii Cat Lamp Tap and Touch Color-Changing LED Changing Lamp |Adorable Room Decor & Gift for Toddlers, Teens (Cat Light Lamp, Regular)

(35)

Now retrieving the price.

(as of April 3, 2025 02:52 GMT +05:30 - )

Mee Mee Baby Steel Feeding Bottle | Baby Milk Bottle with Advanced Anti Colic Valve, BPA Free, Soft Silicone Teat, Wide Neck for Babies/Infants/Newborns of 0-2 Years (240ml)

(2)

₹499.00 (as of April 3, 2025 02:52 GMT +05:30 - )

Foldable Wooden Mini Laptop Table for Bed, Smart Study Table with Drawer Kids & Adults (US-COTTEDS .Wood.)

(67)

₹379.00 (as of April 2, 2025 20:08 GMT +05:30 - )

STRIFF World Map Extended Size (800 mm x 300 mm x 2 mm) Gaming Mouse Pad| Desk Mat | Stitched Edges| Non-Slip Rubber Base|Computer Laptop|Keyboard Mouse Pad for Office & Home (World Map)

₹206.00 (as of April 2, 2025 20:08 GMT +05:30 - )

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 4 HRS)

₹1,399.00 (as of April 2, 2025 20:08 GMT +05:30 - )

Dyazo 6 Angles Adjustable Aluminum Ergonomic Foldable Portable Tabletop Laptop/Desktop Riser Stand Holder Compatible for MacBook, HP, Dell, Lenovo & All Other Notebook (Silver)

₹349.00 (as of April 2, 2025 20:08 GMT +05:30 - )

Dyazo Water Resistant Laptop Sleeve with Handle Compatible for 15 Inch to 15.6" Inches laptops & Notebooks - Grey

₹299.00 (as of April 2, 2025 20:08 GMT +05:30 - )