MySQL Database Creator

This script converts a .txt in a tabular form to mysql table.

Datatype detection

This script detects different kinds of dataype and add them acordingly to the table such as:

1. Date
2. int
3. str

Example:

• This is the txt file

  11 RADHE SHYAM SUPERVISOR P001 13-SEP-04 23-AUG-81

  12 CHANDER NATH OPERATOR P003 22-FEB-10 12-JUL-87

  13 FIZZA OPERATOR P003 14-JUN-09 14-OCT-83

  15 AMEEN AHMED MECHANIC P002 21-AUG-06 13-MAR-84

  18 SANYA CLERK P002 19-DEC-05 09-JUN-83

• And this is the table created