Library tutorials & articles
MySQL Tutorial
- Introduction
- Getting Started
- Creating and Deleting Databases
- Creating Tables
- Using Indexes
- Altering Tables
- The SELECT statement
- The INSERT statement
- The UPDATE statement
- The DELETE statement
Creating and Deleting Databases
Creating a Database
The CREATE statement is used to create a database in MySQL. The following
statement creates a database called search.
mysql> CREATE DATABASE search;
To let MySQL know that you want to use that
database, you use the USE statement. The following example uses the database,
search.
mysql> USE search;
Deleting a Database
Databases can be deleted using the DROP statement. The following example
deletes the database, search.
mysql> DROP DATABASE search;
I'm available for contract work. Please visit Juicify for details.
Related articles
Related discussion
-
Im having problems updating a mysql database with php using a form
by chris jonesy (3 replies)
-
code highlighting using jquery
by pjm (1 replies)
-
Malaysia Web Design Projects (MWDP)
by karsin (0 replies)
-
Using PHP and IIS to Create a Discussion Forum
by waja126 (42 replies)
-
Drag and drop tables, with database update, without anything in the <head> tag
by JamesF (0 replies)
Related podcasts
-
Scaling Large Web Sites with Joe Stump, Lead Architect at DIGG
Have you ever wanted to learn how top 100 web sites are architected? Deep Fried Bytes hosts Keith Elder and Chris Woodruff sat down with Joe Stump, Lead Architect at DIGG to discuss scaling large web sites, his life, development experiences and team building. Listen to the showThanks to our gues...
Events coming up
-
Jul
18
WordCamp UK 2009
Cardiff, United Kingdom
This is the second WordCamp UK - an informal annual gathering of WordPress publishers, designers and developers based in the United Kingdom.
More good mysql examples:
http://www.examplenow.com/mysql/alter
--John
Dear Sir/ Madam
I need your help, how to done replication method in MySQL Server. or if any automatic schedule scripting awailble. pls send my mail id as soon as possible.
i will waiting for your mail
email : vinaymeetu@ymail.com, or vinaywaiting4u@gmail.com,
Regards
Vinay.G.Liyar
This thread is for discussions of MySQL Tutorial.