|
Published on 6/19/2010,
by Dotnetindex
CREATE DATABASE statement will create the database with the given name you specified. IF NOT EXISTS is an option part of the statement, this part prevents you from error if there is a database with the given name exists on the database server. In our tutorial, for example, to create classicmodels database, you just only apply CREATE DATABASE statement above as follows 632 hits |
|
|
Published on 6/2/2010,
by Site Editor
In mySQL there is a
magic function named describe.You may get some specific
information about a database table. Thisfunction returns all columnswith
their data types, default values and some extras. 1008 hits |