How to create a table in a particular database?

Question

The create database statement is:

CREATE TABLE table_name ( column_name1 data_type, column_name2 data_type, column_name3 data_type, .... )

but, I'm wondering how can I create a table in a specific database?

thanks, guys!

Answer 1

USE dbname;

http://dev.mysql.com/doc/refman/5.1/en/use.html

Answer 2

Assuming that you have more than one database, in mysql, you can do SHOW DATABASES to view them all and then USE with your db name to make it the current one. Running CREATE TABLE will then create the table in that database.

Answer 3

You can specify the DB Name in the same query:

CREATE TABLE database_name.table_name ( column_name1 data_type, column_name2 data_type, column_name3 data_type, .... )