Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Create a Database
How To Create a Database? - PHP Script Tips - Working with MySQL Database
✍: 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 a the administrator of the server, you can create and delete databases using the CREATE/DROP DATABASE statements. The following PHP script shows you how to create and drop an database called "fyi":
<?php $con = mysql_connect('localhost'); $sql = 'CREATE DATABASE fyi'; if (mysql_query($sql, $con)) { print("Database fyi created.\n"); } else { print("Database creation failed.\n"); } $sql = 'DROP DATABASE fyi'; if (mysql_query($sql, $con)) { print("Database fyi dropped.\n"); } else { print("Database drop failed.\n"); } mysql_close($con); ?>
If you run this script, you will get something like this:
Database fyi created. Database fyi dropped.
2007-04-18, 4803👍, 0💬
Popular Posts:
What are secure and non-secure websites? A secure Website uses the Secure Socket Layer (SSL) protoco...
Have you ever worked with Microsoft Application Blocks, if yes then which? Application Blocks are C#...
Is XHTML Element Name Case Sensitive? - XHTML Tutorials - Introduction To Tag and Attribute Syntax Y...
How can you write a loop indefinitely? Two examples are listed in the following code: for(;;) { ... ...
How To Control Vertical Alignment? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells By d...