MySQL

MySQL is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius 's daughter, and " SQL ", the abbreviation for Structured Query Language .

MySQL is free and open-source software under the terms of the GNU General Public License , and is also available under a variety of proprietary licenses. MySQL was owned and sponsored by the Swedish company MySQL AB , which was bought by Sun Microsystems (now Oracle Corporation ). In 2010, when Oracle acquired Sun.

What is MySQL?

  1. MySQL is a database system used on the web
  2. MySQL is a database system that runs on a server
  3. MySQL is ideal for both small and large applications
  4. MySQL is very fast, reliable, and easy to use
  5. MySQL uses standard SQL
  6. MySQL compiles on a number of platforms
  7. MySQL is free to download and use
  8. MySQL is developed, distributed, and supported by Oracle Corporation
  9. MySQL is named after co-founder Monty Widenius's daughter: My
The data in a MySQL database are stored in tables. A table is a collection of related data, and it consists of columns and rows.
Databases are useful for storing information categorically. A company may have a database with the following tables: Employees, Products, Customers, Orders , etc.

Download MySQL Database

If you don't have a MySQL Database, you can download it for free here: http://www.mysql.com

Facts About MySQL Database

MySQL is the de-facto standard database system for web sites with HUGE volumes of both data and end-users (like Facebook, Twitter, and Wikipedia). Another great thing about MySQL is that it can be scaled down to support embedded database applications.
Look at http://www.mysql.com/customers/ for an overview of companies using MySQL.

Database Queries

A query is a question or a request.

We can query a database for specific information and have a recordset returned.

Look at the following query (using standard SQL):

SELECT FirstName FROM Class10;

The query above selects all the data in the "FirstName" column from the "Class10" table.

HISTORY

MySQL was created by a Swedish company, MySQL AB , founded by David Axmark , Allan Larsson and Michael "Monty" Widenius . Original development of MySQL by Widenius and Axmark began in 1994. The first version of MySQL appeared on 23 May 1995. It was initially created for personal usage from mSQL based on the low-level language ISAM , which the creators considered too slow and inflexible. They created a new SQL interface, while keeping the same API as mSQL. By keeping the API consistent with the mSQL system, many developers were able to use MySQL instead of the (proprietarily licensed) mSQL antecedent.

Youtube Video Links:

1. MySQL Lecture-1
2. MySQL Lecture -2 (DataTypes and SQL Commands)

MySQL Notes Links:-

1. MySQL Getting Started
2. MySQL Functions
3. MySQL Types Of Functions & JOINs
4. Database Transaction (TCL Commandas )

Tea Or Coffee

PYTHON

Ways to Keep Your Brain Healthy