create database
PHP MySQL Database
PHP MySQL Database
In the previous tutorial, we create PHP Connection To MySQL. For this follow-up tutorial, I decided to make a tutorial on How To Create MySQL Database. For creating a database, it will consist one or more tables in one database.SQL Create Database Statement
Besides creating the database from the DBMS software like Oracle, MyQL, Microsoft Access etc. We can also create database with the query language. It is as simple as writing a SELECT, INSERT, UPDATE, DELETE Statement.
Creating a database using query language is very useful if for example you deploy your application to a computer that doesn’t have a database yet.
We can create a new database with the following syntax
SQL Create Database Syntax
How to Create Database in SQL Server 2005 Express Edition
In this tutorial you will learn how to create a Database in SQL Server 2005 Express Edition. The name of the database that we are going to create is “LibSys” which stands for Library System.
Note that I am using SQL Server Management Studio that is bundled with SQL Server 2008 R2. Regardless of version that you are using the environment still looks the same.
Please follow the steps below to create a database.