Archive:PHP and MySQL Programming/Creating a Database: Difference between revisions
wikademia>Wikademia m moved PHP and MySQL Programming/Creating a Database to Archive:PHP and MySQL Programming/Creating a Database over redirect |
|||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 5: | Line 5: | ||
Now a days, mysql is the one of the mostly used relational database among others as it is simple, free (free source), easy to maintain and cost effective. | Now a days, mysql is the one of the mostly used relational database among others as it is simple, free (free source), easy to maintain and cost effective. | ||
In order to store data into MySQL, it is thus obvious that we will need to prepare a space in MySQL for a table of data known as a | In order to store data into MySQL, it is thus obvious that we will need to prepare a space in MySQL for a table of data known as a database. | ||
== SQL Code == | == SQL Code == | ||
The code for creating such a database in SQL (Sequential Query Language) is a simple query : | The code for creating such a database in SQL (Sequential Query Language) is a simple query : | ||
<br> | |||
mysql> CREATE DATABASE `database_name`; | mysql> CREATE DATABASE `database_name`; | ||