The create database statement is:

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

but, I am wondering how do i produce a table inside a specific database?

thanks, men!

You are able to specify the DB Title within the same query:

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

Presuming you have several database, in mysql, that you can do SHOW DATABASES to see all of them after which USE together with your db title to really make it the present one. Running CREATE TABLE will produce the table for the reason that database.