fork download
copy 
  1. -- Create the database
  2. CREATE DATABASE IF NOT EXISTS employee_db;
  3.  
  4. -- Use the database
  5. USE employee_db;
  6.  
  7. -- Create the EMPLOYEE table
  8. CREATE TABLE EMPLOYEE (
  9.     EMPNO INT NOT NULL,
  10.     FIRSTNME VARCHAR(12) NOT NULL,
  11.     MIDINIT CHAR(1) NOT NULL,
  12.     LASTNAME VARCHAR(15) NOT NULL,
  13.     WORKDEPT CHAR(3),
  14.     PRIMARY KEY (EMPNO)
  15. );
  16.  
Success #stdin #stdout 0.04s 25476KB
comments (?)
stdin
copy 
application/
├── controllers/
│   └── Employee.php
├── models/
│   └── Employee_model.php
├── views/
│   ├── employee_list.php
│   ├── employee_add.php
│   ├── employee_delete.php
│   └── employee_view.php  (Optional - for viewing details)
stdout
copy 
-- Create the database
CREATE DATABASE IF NOT EXISTS employee_db;

-- Use the database
USE employee_db;

-- Create the EMPLOYEE table
CREATE TABLE EMPLOYEE (
    EMPNO INT NOT NULL,
    FIRSTNME VARCHAR(12) NOT NULL,
    MIDINIT CHAR(1) NOT NULL,
    LASTNAME VARCHAR(15) NOT NULL,
    WORKDEPT CHAR(3),
    PRIMARY KEY (EMPNO)
);
https://ideone.com/X1QBuT
language:
PHP (php 7.3.5)
created:
1 day 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!