How to create a table in a particular database? Code Answer

Hello Developer, Hope you guys are doing great. Today at Tutorial Guruji Official website, we are sharing the answer of How to create a table in a particular database? without wasting too much if your time.

The question is published on by Tutorial Guruji team.

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?

Answer

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, .... )

We are here to answer your question about How to create a table in a particular database? - If you find the proper solution, please don't forgot to share this with your team members.

Related Posts

Tutorial Guruji