Skip to main content

Posts

Showing posts with the label how to use the database in mysql

Using the Database

    Creating a database has no effect on which database currently is selected as the default database.  To make  the new database the default database, issue a USE statement:   USE my_db;  After a database has been created, it can be populated with objects such as tables or stored routines.  The  CREATE statement for tables is discussed in a later chapter.  Displaying Database Structure   The easiest way to display the database structure (as far as the database container) is to issue a SHOW CREATE DATABASE command. This command shows the  CREATE DATABASE statement that was used to create  the database (or could be used to recreate the database structure):   mysql> SHOW CREATE DATABASE my_db\G  ************************* 1. row *************************         Database: my_db         Create Database: CREATE DATABASE `my_db`                   /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_danish_ci */ Note: SCHEMA can be interchanged with DATABASE to perform the a