Sql create database

This article is tagged with: Sql create database and mysql

create new database

CREATE DATABASE database;

sql crate database

CREATE DATABASE databasename;

create database sql

CREATE TABLE example (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(50) NOT NULL UNIQUE,
password VARCHAR(255) NOT NULL,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);

sql create database

Creates a new database.
Example: Creates a new database named ‘websitesetup’.
CREATE DATABASE websitesetup;

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;

sql create db command

CREATE DATABASE databasename;

This article is tagged with: Sql create database and mysql