create_emp

create_emp_dbms1

Objective;

Unlike Oracle and PostgreSQL, SEQUENCE , is not available in MySQL, and you have to use Auto-Increment function.
Date : year-moth-day only
testing with MySQL-Query-Tool using PHP
http://manas9/BareBone_MySQL/Mysqli_query_Tool.php

Loading Oracle table Scott In MySQL database.

No SEQUENCE

PostgreSQL: Supports Sequence.

MYSQL data format is restricted, must have Year-month-date format

Now back to MySQL :

Dept table:

And So On

Testing Online with PHP code: