What is MySQL database.
Full form of MySQL is my structured query language. MySQL is open source database management system used by millions of websites, applications, software to store their data in it. Database is a place where all the text format information collect on a single location in Tabular format. MySQL database hold most useful position on dynamic web application development scope.
Why MySQL database is extremely important in php development ?
Because dynamic php websites invoke all of there text statements from MySQL database each & every time web page reloads. Absence of database, web server can not serve dynamic content. Every database contain tables. Tables are the combination of rows and columns. There are thousands of tables in a database and everyone of them endue rows + columns structure to hold the information. Every part of information is saved on columns.
How to create MySQL database in phpmyadmin.
1. The primarily step to create database is Install XAMPP APACHE SERVER so read my guide for installation.
2. After completing installation and stat the Apache & MySQL server open your web browser.
3. Type localhost/phpmyadmin in the url bar then press enter.
4. Click on New.
5. Enter your database name then click on Create button.
6. After press Create button you will see a message " Database YourDatabaseName has been created ".
-
To Open your existing database in PHPMYADMIN exclusively click on it.
Creating tables in phpmyadmin.
1. Select & open your database -> Enter your table name and column count.( Columns are the part of tables like id, name, father_name, address. age ).
2. Now enter column name, Type ( Data type), length Values and if you are creating id column name then you must have to define id increment A_I .
After done all the process it will show newly created table.
No comments:
Post a Comment