www.pickatutorial.com Computer Tutorials
Top eBooks: C/C++ | C# | Android | Mathematics | Database | Cloud | Graphics | Networking | Oracle | Hardware | AI
Top Tutorials: C/C++ | C#.NET | PHP MySQL | Java | Java Script | jQuery | HTML | xHTML | HTML5 | VB Script| CSS
Lessons What is MySQL? Bookmark and Share
Lesson 1
Lesson 2
Lesson 3
Lesson 4
Lesson 5
Lesson 6
Lesson 7
Lesson 8
Lesson 9
Lesson 10
Lesson 11
Lesson 12
Lesson 13
Lesson 14
Lesson 15
Lesson 16
Lesson 17
Lesson 18
Lesson 19
Lesson 20
Lesson 21
Lesson 22
Lesson 23
Lesson 24
Lesson 25
Lesson 26
Lesson 27
Lesson 28
Lesson 29
Lesson 30
Lesson 31
Lesson 32
Lesson 33
Lesson 34
Lesson 35
Lesson 36
Lesson 37
Lesson 38
Lesson 39
Lesson 40
Lesson 41
Lesson 42
Lesson 43
Lesson 44
What is MySQL?
MySQL is a database and a database management system. Strictly speaking MySQL is the most popular open-source database system.

Like any other relational database system, the data in MySQL is stored in tables. A table consists of rows and columns. Columns are also referred to as attributes and the rows are also known as records.

A table is a collections of related data entries. A database may have one of more tables. Each table has a name to identify it in the database.

Databases are really very useful when we need to store categorized information. For example a university may have a database with the following tables:

"Students",
"Faculty",
"Subjects" and
"Classes".

Following is an example of a database table called "students":
Name Class GPA Address
Danial BCS 3.21 Danial House
Jacob MBA 3.65 Jacob House
Adam BSC 2.45 Adam House
The abve table contains three records (one for each student) and four columns (Name, Class, GPA, and Address).

What are MySQL database Queries?
A query is a question or a request. A MySQL database query is a question or a request to the MySQL database that is written in a specific format. Through a database query we request the database management system for some specific information. In response to a query MySQL returns a recordset having the specific information that was requested through the query.

Example

SELECT Name FROM students


The above query selects all the data in the "Name" column from the "students" table, and returns a recordset like following:

LastName
Danial
Jacob
Adam



Home - Advertise - Contact - Disclaimer - About Us
© Since 2006 pickatutorial.com -- All Rights Reserved.