how to create database and table in sql code example

Example 1: 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

);

Example 2: sql create database

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

Tags:

Sql Example

Related