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]

HUNCHA Straw Cleaner Brush Set, 2-Piece Long Cleaning Brush for Straws on Tumbler, Water Bottle, Sippy Cup, and Pipes, Tubes or Hummingbird Feeders
4.1 out of 5 stars(16)
₹75.00 (as of November 21, 2024 11:50 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 Carrot for 6-24 months baby | Omega 3 Iron Protein Calcium for babies | Instant infant Cereal | Travel Friendly | 300g

Now retrieving the price.

(as of November 21, 2024 11:50 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.)
Mee Mee Caring Baby Wet Wipes with lid, 72 Pcs (Aloe Vera, Pack of 3)
4.4 out of 5 stars(59244)
₹216.00 (as of November 21, 2024 11:50 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.)
Pampers Active Baby New Born Diapers (72 Count)
4.4 out of 5 stars(71855)
₹1,032.00 (as of November 21, 2024 11:50 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.)
StarAndDaisy Diaper Bag for New Born Baby/Maternity Bags for Mother with Multi Compartments, Insulated Bottle Pockets, Waterproof, Ultra soft leatherite fabric, 24lt capacity - Green & Yellow
₹1,398.00 (as of November 21, 2024 11:50 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
4.4 out of 5 stars(90704)
₹313.00 (as of November 21, 2024 11:50 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
3.6 out of 5 stars(8564)
₹499.00 (as of November 21, 2024 11:50 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
4.3 out of 5 stars(54127)
₹215.00 (as of November 21, 2024 11:50 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), 128 Count, 9-14 kg
4.3 out of 5 stars(48945)
₹1,611.00 (as of November 21, 2024 11:50 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.)
Amazon Brand - Supples Premium Diapers, Large (L), 62 Count, 9-14 Kg, 12 Hrs Absorption Baby Diaper Pants
4.0 out of 5 stars(44308)
₹525.00 (as of November 21, 2024 11:50 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 Cruzer Blade 32GB USB Flash Drive
4.3 out of 5 stars(259701)
₹319.00 (as of November 21, 2024 01:29 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.)
Dell MS116 Wired Optical Mouse, 1000DPI, LED Tracking, Scrolling Wheel, Plug and Play
4.4 out of 5 stars(41843)
₹284.00 (as of November 21, 2024 01:29 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.)
Oneplus Original Fast 80W USB Type C Data Sync Fast Charging Charger Cable for One Plus 12,12r,11,11r,10r,10t,10,10 pro,9 Pro,8,8T,7t,7t Pro,6,Nord,4,3,2,2t,Ce2 Lite,Ce3 lite,Nord Ce3,Ce4, By Tu-dox
4.7 out of 5 stars(1361)
₹379.00 (as of November 21, 2024 01:29 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.)
ZEBRONICS Zeb-Jaguar Wireless Mouse, 2.4GHz with USB Nano Receiver, High Precision Optical Tracking, 4 Buttons, Plug & Play, Ambidextrous, for PC/Mac/Laptop (Black+Grey)
3.9 out of 5 stars(9366)
₹299.00 (as of November 21, 2024 01:29 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.)
ZEBRONICS MSP-X1 Mouse Pad, for Speed and Precision Operation, Smooth Cloth Surface, Roll and Go, Optimised for All Mouse Sensors, Anti Slip Rubber Base, Surface of 232 x 182 mm
4.3 out of 5 stars(240)
₹99.00 (as of November 21, 2024 01:29 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.)
  • Share