Web development by MySQL.

Many ways to do web development. One of them  MySQL. Do you know? What is MySQL? This question has a answer. It is  a database program. Databases are stay safely MySQL object. These are called Table. Tables are about data entries collect and it has some column and lines. When the information's save to according category then the database will be very useful to a web. Such as: Suppose, A company has a database. That database tables some tables. There are: Name, Employees, Products, Customers and orders etc. Many people guess Mysql is only small and simple database system. In fact, It is nice and on the whole database. The real matter is that Mysql is a large valium. It supports much development system. A web site for it best useful.

What is MySQL database table?

Generally MySQL database carry one or more tables. Each table selected by a name. Example: Customer or Order. Other hand, Seller and buyer. Tables carry data's records( rows). Another example: A table has  created that name is Mohin. 

Fast name	Last name	Address	Country
Mohin	Islam	Dilly	India
Maliha	Islam	Dhaka	Bangladesh
Sean	Chon	China	China
Nella	seto	USA	USA

Learner friends we have seen  a  MySQL database table. It is to create Mysql platform. Now we will see What is Queries?

That question has a answer. Queries is a question or request. We can  make a queries  by MySqL database for independent information and we can bake a record set. Let go to see. How to create a queries.

Select first Name Form  Persons

Above the queries will be elect all data's and it will be return record set  same bellow:

First name

Mohin

Maliha

Sean

Nella

How to download MySQuL server easily?

If you have not Mysql and PHP server. Then you go to this link: http:// www.mysql.com/downloads/index.html. It's free download or open source software. Nowadays most of the programmer has installed “XAMP or WAMP Server. It is best for us. XAMP is an Apache web server. It has both mysql and php facilities. You can use any. As a result, your Pc will be same a server. You can use database here. We give a tutorial about XAMP. We give a post about XAMP installation method.

How to work MySQL ?

At first you have to  install the XAMP web server. Installing the software, you open it . Then start your work step by step.

(i)  Enter the xamp control exe. Opening it, a new window will come. It will look same image as. Than click  apache and mysql start button and minimize the window.

(2) Now start a browser. Starting the browser, write ' http://localhost/phpmyadmin/ ' on browser address bar. Don't write search bar. If you understand it. Look the image bellow. Remember, Here, needn't internet connection. It will work without any network. Because, XAMP is a server.

Creating database:

Dear learners, Now learn how to create a database? Look the image " create new database" here write your database name. such as: "World It" and then click : create button. Now you will see a massage world It database has been created.

(3) You have to a new table and some fields this database. See the left side. You will see your database "world It". Then click it. Then you get a field , create new database world IT . Now write Name : Mohin   Number of fields: 5 and click  Go button. A new page open here. You have to fill up the field. Next lesson we will learn how to fill up the fields here. You my interested it. write your opinion  here. Do you have any question about MySQL.