fork download
copy 
  1. CREATE TABLE users (
  2.     id BIGINT PRIMARY KEY AUTO_INCREMENT,
  3.     full_name VARCHAR(150) NOT NULL,
  4.     employee_number VARCHAR(20) UNIQUE NOT NULL,
  5.     phone VARCHAR(20),
  6.     email VARCHAR(100),
  7.     password VARCHAR(255) NOT NULL,
  8.     role_id BIGINT,
  9.     branch_id BIGINT,
  10.     status ENUM('active','inactive') DEFAULT 'active',
  11.     created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  12.     updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  13. );
Success #stdin #stdout #stderr 0s 5320KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Error: near line 1: near "AUTO_INCREMENT": syntax error
https://ideone.com/v1Jo5u
language:
SQLite (sqlite 3.27.2)
created:
8 hours ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!