Skip to content

Instantly share code, notes, and snippets.

@zsiddiqi

zsiddiqi/oracle2mysql.sed

Forked from jabley/oracle2mysql.sed
Created July 13, 2016 20:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save zsiddiqi/56876b3be7d0576147798738553a0043 to your computer and use it in GitHub Desktop.
Save zsiddiqi/56876b3be7d0576147798738553a0043 to your computer and use it in GitHub Desktop.
Download ZIP
Help convert Oracle DDL to MySQL
Raw
oracle2mysql.sed
s/NUMBER(22,0)/BIGINT/
s/NUMBER(9,0)/INT/
s/NUMBER(8,0)/INT/
s/NUMBER(6,0)/MEDIUMINT/
s/NUMBER(5,0)/SMALLINT/
s/NUMBER(3,0)/TINYINT/
s/NUMBER(2,0)/TINYINT/
s/NUMBER(1,0)/BIT/
s/NUMBER(16,2)/DECIMAL(16,2)/
s/NUMBER(11,2)/DECIMAL(11,2)/
s/NUMBER(9,2)/DECIMAL(9,2)/
s/NUMBER(7,2)/DECIMAL(7,2)/
s/NUMBER(5,2)/DECIMAL(5,2)/
s/NUMBER(4,2)/DECIMAL(4,2)/
s/NUMBER/BIGINT/
s/VARCHAR2/VARCHAR/
s/"//g
s/--.*//
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment