 Homepage | ♣ Fav. | About | G. search | Keywords | Blog | 
|
| CODES All Codes » GENERATORS ---------------- All Generators » SCRIPTS Latest Scripts » LAYOUTS & GRAPHICS TOOLS All Tools » TUTORIALS Latest Tutorials » LESSONS |
| 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...