MYSQL DATABASE | DOWNLOAD MYSQL | MYSQL COMMANDS AND VERSIONS

MYSQL DATABASE -

Developed By- Oracle Corporation.

Initial Release Date- 23/05/1995.

Written In-c,c++.

MySQL is an open-source relational database management system. MySQL is used by many database web applications like Drupal, Joomla, and WordPress etc. MySQL is also used by many popular websites like Facebook,Twitter, and YouTube.

MySQL is a fast, easy to use RDBMS being used for many small and big businesses and it is so demanding. MySQL is developed by Oracle Corporation.

MySQL is released under an free open-source license. So you have not to pay to use it. it is free for every user.

MySQL is a very powerful program database. It handles a large subset of the functionality of the most high expensive and powerful  high database packages.

MySQL uses a standard form for the well known SQL data language.

MySQL works on many operating systems and with many languages like PHP, PERL, C, C++, JAVA, etc.

MySQL works very quickly and  fast works well even with large amount of data sets. and it is very fast.

MySQL is very friendly to PHP language, the most appreciated language for web development.

versions -  

• mysql version 3.19  release date - 23/05/1995                       
• mysql version 3.20  release date - 01/1997                        
• mysql version 3.21  release date - 1998                                      
• mysql version 3.22  release date - 1998                                     
• mysql version 3.23  release date - 06/2000                                 
• mysql version 4.0  release date - 08/2002                                 
• mysql version 4.1  release date - 06/2004                                     
• mysql version 5.0  release date - 03/2005                              
• mysql version 5.1  release date - 14/11/2008                       
• mysql version 5.5  release date - 03/12/2010                         
• mysql version 5.6  release date - 05/02/2013                      
• mysql version 5.7  release date - 21/10/2015                      
• mysql version 8.0  release date - 19/04/2018

  
commands -

To login (from unix shell) use -h only if needed ------ [mysql dir]/bin/mysql -h hostname -u root -p
Create a database on the sql server. --- create database [databasename];

List all databases on the sql server. ---- show databases;

Switch to a database. --- use [db name];

To see all the tables in the db. ---show tables;

To see database's field formats.---- describe [table name];

To delete a db. ---- drop database [database name];

To delete a table. --- drop table [table name];

Show all data in a table.---- SELECT * FROM [table name];

Returns the columns and column information pertaining to the designated table.---- show columns from [table name];

Show unique records. ---- SELECT DISTINCT [column name] FROM [table name];


Delete a column. ---- alter table [table name] drop column [column name];