PHP MySQL Database

With PHP, you can connect to and manipulate databases.
MySQL is the most popular database system used with PHP.

What is MySQL?

  • MySQL is a database system used on the web
  • MySQL is a database system that runs on a server
  • MySQL is ideal for both small and large applications
  • MySQL is very fast, reliable, and easy to use
  • MySQL uses standard SQL
  • MySQL compiles on a number of platforms
  • MySQL is free to download and use
  • MySQL is developed, distributed, and supported by Oracle Corporation
  • MySQL is named after co-founder Monty Widenius's daughter: My

    • The data in a MySQL database are stored in tables. A table is a collection of related data, and it consists of columns and rows.

    What is Database?

    A Database is a collaction of information that is organized so that it can be easily,access,managed and update.

    Database Queries

    A query is a question or a request.

    We can query a database for specific information and have a recordset returned.

    Query is just like a Question.

    A Query is an enquiry into the database using Select Statment.

    Query is used to extract data from the database in a readable formate according to the user's request.

    Previous

    Next