It is used to create database.
Syntax:- CREATE DATABASE database_name;
Ex:- CREATE DATABASE my_db;
Guide for creation of database:-
Name should start with an alphabet
Blank space and single quotes are not allowed
Reserve words of that RDBMS/DBMS can not be used as database name
Use a database
This is used to tell your RDBMS/DBMS that you want to use this database.
Syntax:- USE database_name;
Ex:- USE my_db;
Syntax:- CREATE DATABASE database_name;
Ex:- CREATE DATABASE my_db;
Guide for creation of database:-
Name should start with an alphabet
Blank space and single quotes are not allowed
Reserve words of that RDBMS/DBMS can not be used as database name
Use a database
This is used to tell your RDBMS/DBMS that you want to use this database.
Syntax:- USE database_name;
Ex:- USE my_db;
Posts
0 Comments:
Post a Comment