Go Back   Wiki NewForum > Career Forum (Documents/Tutorials/Advice) > Tech Forum & Tutorial > PHP Forum & Tutorial

PHP Forum & Tutorial PHP Tutorial, Codes, Examples & Full End-To-End Process

Reply
Views: 941 Source: CNN18.com, India-Forums, TellyChakkar, India, Times of India, Youtube, BollywoodLife, Rediff  
Thread Tools Rate Thread Display Modes
  #1  
Old 05-04-2009, 05:43 PM
welcomewiki welcomewiki is offline
Member
 
Join Date:
Dec 2008
Location:
India
Posts: 39,034
Default PHP MySQL Introduction

MySQL is the most popular open-source database system.
What is MySQL?

MySQL is a database.


The data in MySQL is stored in database objects called tables.
A table is a collections of related data entries and it consists of columns and rows.


Databases are useful when storing information categorically. A company may have a database with the following tables: "Employees", "Products", "Customers" and "Orders".




Database Tables

A database most often contains one or more tables. Each table is identified by a name (e.g. "Customers" or "Orders"). Tables contain records (rows) with data.


Below is an example of a table called "Persons":




LastName FirstName Address City Hansen Ola Timoteivn 10 Sandnes Svendson Tove Borgvn 23 Sandnes Pettersen Kari Storgt 20 Stavanger The table above contains three records (one for each person) and four columns (LastName, FirstName, Address, and City).



Queries

A query is a question or a request.
With MySQL, we can query a database for specific information and have a recordset returned.


Look at the following query:




SELECT LastName FROM Persons



The query above selects all the data in the "LastName" column from the "Persons" table, and will return a recordset like this:





LastName Hansen Svendson Pettersen

Ads
Reply With Quote
Reply

New topics in PHP Forum & Tutorial

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump


Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
asp web stats