Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Help convert Oracle DDL to MySQL
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