forum

home / developersection / forums / there are some problem in creation of database

Ask Question

There are some problem in creation of database

Somesh 3.79 K 26-Oct-2010
how we create database in mysql with php
please give syntex
thanks in advance
mysql mysql 
Updated on 08-Nov-2010
Somesh

Somesh

Follow

Can you answer this question?
Answer

1 Answers

Amit Singh

Amit Singh

08-Nov-2010
Create database between mysql and php
using syntax
Create database databaseName

we write syntax in php for creation of database
 Example
<?php
$con = mysql_connect("localhost","sa","sa");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
if (mysql_query("CREATE DATABASE my_db",$con)) //Create database and check the condition
  {
  echo "Database created";
  }
else
  {
  echo "Error creating database: " . mysql_error();
  }
mysql_close($con);
?>

RELATED INTERVIEW

How do you concatenate strings in MySQL?

What’s the default port for MySQL Server?

how we connect the database in MYSQL?

What are CSV tables?

What are ENUMs used for in MySQL?

RELATED BLOGS

Trigger In SQL

Introduction to SQL

SQL Constraints

SQL Queries

SQL Functions

RELATED ARTICLE

SQL for Data Analytics: Querying and Manipulating Databases

What is MySQL?

SQL Jobs in London | SQL Jobs in Cambridge

Replication in SQL server 2008

PCNSE Paloalto Networks Certified Network Security Engineer Exam Questions Updated -

Related Forum

How to create mysql database backup file using PHP?

SQL Mach two table

MySQL Workbench does not connect over SSH.

How to do custom search in MySQL?

Can I concatenate multiple MySQL rows into one field?

MySQL - Return all items in one row.

YourViews

10 Science-Based Benefits of Yoga

Why Samajwadi Party always support goons and criminals?

Is Mamata Banerjee a threat to India? We must know.

Why didn't all Muslims of India leave for Pakistan at the time of partition?

Muslim Population in India: States with the Highest Muslim Population

Question & Answer

Who composed the music for the highest-grossing Indian film of all time?

Name the Indian director who won the Palme d'Or at Cannes for the first time.

Which South Indian film industry produces the most movies annually: Tamil, Telugu, or Malayalam?

Which Bollywood actor has won the most Filmfare Awards for Best Actor?

Which Indian movie was the first to win an Oscar for Best Foreign Language Film?

Tags

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy