Welcome to Zortin.com

Homepage
Fav.  |  About  |  G. search  |  Keywords  |  Blog

Search for
Click here for a great link





CODES  All Codes »
GENERATORS ---------------- All Generators »
SCRIPTS  Latest Scripts »
LAYOUTS & GRAPHICS
TOOLS  All Tools »
TUTORIALS  Latest Tutorials »
LESSONS

Easy mySQL Tutorial
Easy mySQL tutorial


MySQL (or MySQL database) is very useful for every site owner
it is a database that you can save information and then retreive it
All websites that require registeration are most likely using MySQL database
However, to deal with mySQL, you must be familiar with PHP as mySQL functions best with PHP!
You can refer to the easy PHP tutorial if you need to know more about PHP

Lets talk about MySQL in general
mySQL allows you to store data and information in tables
If you have a website, and you wish to save the details of your members
Example: Name, Age, Gender
You can simply use mySQL database
You first create a table and give it a name, in this case, the table can be called Details
this table should have 3 colombs to store the 3 details we are after
Name, Age, Gender
Therefore, you can start storing your member's details using this table
You can also retreive the stored information using mySQL
The idea is very simple and useful

The table will look something like that
Name Age Gender
John 20 Male
Paula 21 Female


Note that mySQL gives every row a unique id

So, the table will actually be like that
ID Name Age Gender
1 John 20 Male
2 Paula 21 Female


The fact that every row must have a unique id is very important
This unique ID will allow you to choose who's details you are looking for
If you want to display Paula's details, you choose ID = 2
This will display the row which contains Paula details

Creating a table can be done using PHP
phpMyAdmin can also be used, which is an easy tool that allows you to create tables fast and easy
Therefore, if you are using Cpanel, you simply click on mySQL databases then open phpMyAdmin and simply start creating a table


TO BE CONTINUED...