What is MySQL?
MySQL is an open-source relational database management system (RDBMS) that is most widely used in the world, and the most widely used open source client-server RDBMS. MySQL name is a combination of "My" is the name of the daughter of the founder Michael Widenius, and "SQL", stands for Structured Query Language. MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.
Why use MySQL?
There are several reasons why MySQL is widely used in the world of learning and programming, that is:
1. it is open source or free so it can be used legally in all activities.
2. can work on a variety of platforms, such as Linux, Windows, Mac OS and so on.
3. have a variety of types of data that can support data storage more accurate.
4. supports query to help in processing data.
5. Can be used in various types of programming such as VB6, VB.Net, Delphi 7, C, C ++, Java, Perl, PHP and Python
6. The use of the database can be used for more than one user at the same time (sharing database).
7. Secure the data storage for user access rights can be restricted.
What applications are used in learning MySQL?
to learn mysql can use MySQL client or Xampp which can be obtained via the link below, for how to install to your search on www.google.com.
Mysql client : http://dev.mysql.com/downloads/
Xampp : https://www.apachefriends.org/index.html
Mysql client : http://dev.mysql.com/downloads/
Xampp : https://www.apachefriends.org/index.html
then the following is an index of learning MySql BeCoding Blog:
Step 01: How to view,create, or delete a mysql database
Step 02: How to use database & create a table in MySQL database
Step 03: modify a table with the command 'alter table'
Step 04: Create table relationships using the 'alter table' command
Step 05: How to enter and display data from the table mysql
Step 06: How to display the data in a database table mysql
Step 07: How to update the data in the table
Step 08: How do I delete existing data in the table mysql
Step 09: Learn to command the query "sum,min,max,avg, and count" in MySQL
Step 10: COMING SOON
other references
01.DATA TYPE IN MYSQL
Tidak ada komentar:
Posting Komentar