PHP - MySQL introduction

mysql(structured query language) is the most popular database system used with php.

mysql is a freely available open source relational database management system(rdbms) that uses structured query language(sql).


what can mysql do ?

  • mysql can create new databases
  • mysql can create new tables in a database
  • mysql can create stored procedures in a database
  • mysql can retrieve data from a database
  • mysql can insert records in a database
  • mysql can update records in a database
  • mysql can delete records from a database
  • mysql can execute queries against a database
  • mysql can set permissions on tables, procedures, and views.

Why MySQL use with PHP

  • mysql is a open source database system that runs on a server.
  • mysql is very fast performance, reliable, and easy to use
  • mysql supports structured query language(sql)
  • mysql manage easily
  • mysql compiles on a number of platforms.
  • mysql database can able store any kind of data types(text, images,media, audio files).

note: you want to learn more about mysql language look our tutorial : mysqltutorial


features of mysql

  • it designed to be fully multi-threaded using kernel threads, to easily use multiple cpus if    they are available.
  • uses a very fast thread-based memory allocation system.
  • supports server secure layer (ssl)
  • cross-platform support
  • full-text indexing and searching using myisam engine
  • embedded database library

  security

  • privilege and password system that is very flexible and secure and that enables host-based verification.

  scalability and limits

  • mysql support for large database that contain 50 million records.

note: you want to learn more about mysql language look our tutorial : mysqltutorial


download MySQL Database : http://www.mysql.com/