MySQLDatabase are huge gathering of logical related information which can be created, accessed, managed, and updated. The data may be in any form like text and numbers.
Many types of data stores are present, such as files on the file system, where data reading and writing will be very slow. So in the present generation, Relational Database Administration framework is being utilized to store and oversee colossal measure of information. All relational database management systems like MySQL, MS Access, Oracle, Sybase, Postgre and SQL Server use SQL as standard database language.
Conceptual
figure
Queries - Is used to fetch the database from the database.
RDBMS - Stands for relational database management system.
Operating system - Which support basic computer functions.
Database - Is a logical related data which is stored in the database.
Examples
The below example describes the sample example of MySQL query.
[sql]
sql> create table student(stu_id number(4),stu_name varchar(255),fee int);
Query OK, 0 rows affected (0.32 sec)
sql> insert into student values(1001,'rock',12000);
Query OK, 1 row affected (0.16 sec)
sql> insert into student values(1002,'hairy',13000);
Query OK, 1 row affected (0.17 sec)
sql> insert into student values(1003,'scena',13000);
Query OK, 1 row affected (0.16 sec)
select * from student;
+--------+----------+-------+
| stu_id | stu_name | fee |
+--------+----------+-------+
| 1001 | rock | 12000 |
| 1002 | hairy | 13100 |
| 1003 | scena | 13000 |
+--------+----------+-------+
3 rows in set (0.00 sec)[/sql]
It will display all the student table values that are stored in the database.
SQL process
Description
MySQL databases are very quick and user friendly database. MySQL is an ANSI (American National Standards Institute) standard but there are many different versions of the SQL language.
MySQL is published under an open-source license agreement.
MySQL handles more expensive and powerful database packages.
MySQL deals with c, c++, PHP, Java and so on and other working frameworks.
MySQL works quick and handle even with tremendous information sets.
MySQL is neighborly to PHP, the most section on dialect for web improvement.
MySQL advances gigantic databases, upto 50 million columns and significantly more in the table. The default size point of confinement of a table is 4GB, however can be stretched out to a hypothetical cutoff of 8 million terabytes (TB).
MySQL is imprint. In general source, GPL permits developers to change the SQL programming to suit their own particular informational system.
Features
Description
The features of MySQL databases are as follows:
High Performance
High Availability
Adaptability and Flexibility Run anything
Robust Transactional Support
Web and Data Warehouse Strengths
Strong Data Protection
Comprehensive Application Development
Management Ease
Open Source Freedom and 24 x 7 Support
Lowest Total Cost of Ownership
Summary
Key Points
MySQL Databases - Are a collection of huge amount of data.
MySQL Process - Describes the supporting versions and features of MySQL Database.