Collections:
Creating a New Database in MySQL
How To Create a New Database in MySQL?
✍: FYIcenter.com
A database in a MySQL server is a logical container used to group tables and other data objects together as a unit. If you are the administrator of the server, you can create a new databases using the CREATE DATABASE statements with MySQL client interface programs.
If you want to create a new database with a PHP script, you can still use deprecated function, mysql_create_db(). But it's better use the mysql_query($sql,$con) function to create new databases. The tutorial exercise below shows you how to create a database called "fyi":
<?php $con = mysql_connect('localhost:8888', 'dev', 'iyf'); $sql = 'CREATE DATABASE fyi'; if (mysql_query($sql, $con)) { print("Database fyi created.\n"); } else { print("Database creation failed.\n"); } mysql_close($con); ?>
If you run this script, you will get something like this:
Database fyi created.
⇒ Failed to Create a Database in MySQL
⇐ List All Existing Databases in MySQL
2017-11-11, 1510🔥, 0💬
Popular Posts:
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...