<< previous page   --   table of contents   --   next page >>
| | | | | | | |
  • Return to Table of Contents
    • Table of Contents
    1. General Information
    2. MySQL Installation
    3. Tutorial Introduction
    4. Database Administration
    5. MySQL Optimisation
    6. MySQL Language Reference
    7. MySQL Table Types
    8. MySQL APIs
    9. Extending MySQL
    468 MySQL Technical Reference for Version 4.0.3 Execute  the  expression  but  don't  return  any  results.    This  is  a  shorthand  of  SELECT expression, expression, but has the advantage that it's slightly faster when you don't care about the result. This is mainly useful with functions that has side e ects, like RELEASE_LOCK. 6.5  Data De nition:  CREATE, DROP, ALTER 6.5.1  CREATE DATABASE Syntax CREATE DATABASE [IF NOT EXISTS] db_name CREATE DATABASE  creates a database with the given name.   Rules for allowable database names are given in Section 6.1.2 [Legal names], page 379.  An error occurs if the database already exists and you didn't specify IF NOT EXISTS. Databases  in  MySQL  are  implemented  as  directories  containing   les  that  correspond  to tables  in  the  database.    Because  there  are  no  tables  in  a  database  when  it  is  initially created, the CREATE DATABASE statement only creates a directory under the MySQL data directory. You  can  also  create  databases  with  mysqladmin.   See  Section  4.8  [Client-Side  Scripts], page 287. 6.5.2  DROP DATABASE Syntax DROP DATABASE [IF EXISTS] db_name DROP DATABASE  drops all tables in the database and deletes the database.  If you do a  DROP DATABASE on a symbolic linked database, both the link and the original database is deleted. Be VERY careful with this command! DROP DATABASE  returns the number of les that were removed from the database directory. Normally, this is three times the number of tables, because normally each table corresponds to a `.MYD' le, a `.MYI' le, and a `.frm' le. The DROP DATABASE command removes from the given database directory all les with the following extensions: Ext Ext Ext Ext .BAK .DAT .HSH .ISD .ISM .ISM .MRG     .MYD .MYI .db .frm All subdirectories that consists of 2 digits (RAID directories) are also removed. In MySQL Version 3.22 or later, you can use the keywords IF EXISTS to prevent an error from occurring if the database doesn't exist. You  can  also  drop  databases  with  mysqladmin.     See  Section  4.8  [Client-Side  Scripts], page 287.
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN REGISTRATION
    MANAGE YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    SITE MAP
    Home
    Hosting Plans | Domain Registration | About Us | Contact Us | Site Map
    Terms of Use | Privacy Policy | Guarantees
    Merchant Accounts

    SpiritHost - web hosting for spiritual and education sites
    SpiritHit.com - Religious and Spiritual Portal

    Copyright © 2002 Dyntex Group, Inc. All Rights Reserved

  • Return to Table of Contents
    		•
  • Back to top
    • Web Hosting: Manuals & FAQ's
    1. Unix-Based Web Hosting
    2. Unix Dedicated Servers
    3. Windows Dedicated Servers
    4. CuteFTP User’s Guide
    5. CuteHTML User’s Guide
    6. WS_FTP Pro User's Guide
    7. Miva Order User's Guide
    8. Miva Merchant User's Guide