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;