Answers for "create database command"

SQL
2

how to create database using cmd mysql

CREATE DATABASE [IF NOT EXISTS] database_name
[CHARACTER SET charset_name]
[COLLATE collation_name]
Posted by: Guest on February-24-2020
1

CREATE DATABASE DatabaseName;

SHOW DATABASES;
 DROP DATABASE testDB;
 USE DatabaseName;
 
 SQL> CREATE TABLE CUSTOMERS(
   ID   INT              NOT NULL,
   NAME VARCHAR (20)     NOT NULL,
   AGE  INT              NOT NULL,
   ADDRESS  CHAR (25) ,
   SALARY   DECIMAL (18, 2),       
   PRIMARY KEY (ID)
);

DESC CUSTOMERS;
Posted by: Guest on August-05-2020

Code answers related to "create database command"

Code answers related to "SQL"

Browse Popular Code Answers by Language