About Mysql Database

So you want to know what is mysql ? Or already now it and want to learn how to use it with php ? In all cases we are here to help you !

Mysql is useful when you want to store data, infos... Yes you can save your data in a text file, but will not be easy to read details, to search, or any other task...

For example, let's say you want to store details of users of your website, every user will have an username, password, and email , you can so create a database, with a table "users", and that table has 3 columns: username; password; email, and each user occupies one line. It's exactly like Excel documents...
In that example, you can store data in a text file, each user per line, his details seperated with ";" , but that will make a big file if you have many users, so script will be slow in reading and writing, and the most important thing: searching.
Mysql is known as a fast database, and very smart one.

You can use many tables in the same mysql database, and with relations between them, which make it the best database.

Mysql is used with php, but has its own language, so php functions will send mysql scripts to mysql server, then the server do the tasks, and send back results to php where you can manipulate them.
You can for example read all details from a mysql table, or insert a new entry, update one, or delete another, or search in the table and get the matching entries, or sort data, or create a new table ...

We will see step by step how to do all that,
Will see you again, bye !

5 comments:

Unknown said...

Lamp Development platform is a highly flexible web application development platform, which offers developers the flexibility to create flawless web applications of their choice.

Unknown said...

Great awesome information about PHP and MySQL. Keep sharing, Thanks for this informative article. Best PHP training in Bangalore

Valentino thomas said...

Once you have an existing schema, you can use the tool to make changes or customize it. For more information on free database designer, read me.

charliesmith said...
This comment has been removed by the author.
charliesmith said...

For UK based companies, there are two main Data Centre locations in London that offer an average of nine carriers with a Point of Presence at each location. For more information on UK colocation discover here.