PRO:
fairly easy syntax
good management tool (phpmyadmin)
easy to integrate and use with PHP, Ruby etc.
very common therefore lots of tutorials and howtos
CONS:
performance
bad or missing RDMS features (like postgreSQL or other systems have)
limited capacities storage-wise
Ultimately PHP is a programming language and MySQL is a database language. Using PHP with MySQL is a nice combination with built-in support and the simplicity of it all. However, there aren't a lot of disadvantages of using PHP with a database, it just allows for better data organization and whatnot. There are definitely advantages and disadvantages to using a database other than MySQL (such as MongoDB or PostgreSQL).
discuss database and field functions
No one knows
The MySQL command is "CREATE DATABASE [dbname]" with "[dbname]" replaced with your desired database name.
MYSQL database
MyISAM is the default table engine in the MySQL database.
WAMP stands for Windows Apache Mysql PHP. Mysql is the default database in WAMP
Wikipedia uses MySQL as its database.
You have several options: * copy the database files from mysql/data/<database_name> to a new mysql Installation * use mysqldump utility to export the data from your database and load it into the new mysql installation * setup replication
Advantages: • High performance • Large capacity • High availability • Incremental growth Disadvantages: • Complexity • Inability to recover from database corruption
Use: $todaysdate = date("d/m/y"); And then just send that to the MySQL database
The developer of the MySQL database software was MySQL AB, which was bought by Sun 2008 for one billion dollars. Oracle then acquire sun and hence MySQL and is currently responsible for the continuing development.