saftutorials.com
PHP WITH MYSQL DB

DATABASE

The database is a collection of information which is stored in an organized way so that it can easily accessible, manageable and updated. Data is organized into tables, rows, and columns and it is indexed to make it easier to find the relevant data. You can say in other words that database is a collection of tables.


MYSQL DATABASE

By using PHP you can connect to the MySQL database system for manipulating data. Mysql is the most popular database system which is used with PHP language. And it is freely available for download and use. Mysql database system run on the server and it is used for the web. Mysql query is easily understandable and it is very fast and reliable. This database system is very useful for small and large web application both.

MYSQL DATABASE QUERY

These are some MySQL database query for creating tables and selecting the rows of the table.

 MYSQL QUERY-> CREATE TABLE student (name VARCHAR(20), mobile VARCHAR(20), email VARCHAR(20), sex CHAR(1), date_of_birth DATE);

When this MySQL query executes a database table named student will be created with the following columns name, mobile, email, sex, and date_of_birth.


MySQL Select Data

MYSQL QUERY-> SELECT * FROM student

When the above MySQL query will execute then select all rows of student table.

Find us on

Facebook Google Plus Twitter Pinterest YouTube

web statistic