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).
The MySQL command is "CREATE DATABASE [dbname]" with "[dbname]" replaced with your desired database name.
No one knows
discuss database and field functions
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
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.
Use: $todaysdate = date("d/m/y"); And then just send that to the MySQL database
Advantages: • High performance • Large capacity • High availability • Incremental growth Disadvantages: • Complexity • Inability to recover from database corruption