Answers for "command for creating database"

SQL

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 "command for creating database"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#