Horje
employee sample data mysql Code Example
employee sample data mysql 
CREATE TABLE employees (
    emp_no      INT             NOT NULL,  -- UNSIGNED AUTO_INCREMENT??
    birth_date  DATE            NOT NULL,
    first_name  VARCHAR(14)     NOT NULL,
    last_name   VARCHAR(16)     NOT NULL,
    gender      ENUM ('M','F')  NOT NULL,  -- Enumeration of either 'M' or 'F'  
    hire_date   DATE            NOT NULL,
    PRIMARY KEY (emp_no)                   -- Index built automatically on primary-key column
                                           -- INDEX (first_name)
                                           -- INDEX (last_name)
);
Source: www3.ntu.edu.sg



Sql

Related
alasql delete column Code Example alasql delete column Code Example
postgresql replace html tags from string Code Example postgresql replace html tags from string Code Example
how to create enum in postgreSQL Code Example how to create enum in postgreSQL Code Example
SQL BULK INSERT Code Example SQL BULK INSERT Code Example
mysql case sensitive Code Example mysql case sensitive Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 8



 

Horje