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, 1323🔥, 0💬
Popular Posts:
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...