##################################### # MySQL À» Oracle ·Î ÀÌÀüÇϱâ # ##################################### ÀÛ¼ºÀÚ : ÀåÇüÈ(hhjang97@venus.uos.ac.kr) ÀÛ¼ºÀÏ : 2005. 03. 08 ¼öÁ¤ÀÏ : ¿øº» : ¼³¸í : MySQLÀÇ ³»¿ëÀ» Oracle·Î ¿Å±â¸é¼ »ç¿ëÇÑ ³»¿ëÀ» Á¤¸®ÇÔ ################################# ################################# ################################# 1. µ¥ÀÌÅÍ Å¸ÀÔÀ» ¹Ù²Û´Ù. MySQL ¸Þ´º¾ó : 7.2 Column types Âü°í int(11) => number(11) varchar(30) => varchar2(30) char(30) => char(30) TINYINT => number(3) : 255 SMALLINT => number(5) : 65535 MEDIUMINT => number(8) : 16777215 INT => number(10): 4294967295 BIGINT => number(20): 18446744073709551615 FLOAT => : 1.175494351E-38 to 3.402823466E+38 DOUBLE => : 2.2250738585072014E-308 to 1.7976931348623157E+308 DECIMAL => DATE => : 'YYYY-MM-DD' DATETIME => : '1000-01-01 00:00:00' to '9999-12-31 23:59:59' TIMESTAMP => number(11) TIME => : 'HH:MM:SS' YEAR => : 1901 to 2155 CHAR => CHAR VARCHAR => VARCHAR2 TINYBLOB TINYTEXT => CHAR(255) TEXT => VARCHAR2(65535) : (2^16 - 1) BLOB MEDIUMBLOB MEDIUMTEXT => VARCHAR2(16777215) : (2^24 - 1) LONGBLOB LONGTEXT => VARCHAR2(4294967295) : (2^32 - 1) ENUM SET 2. auto_increment ÀÎ °æ¿ì sequence °ªÀ» ¸¸µç´Ù. - "Å×À̺íÀ̸§_seq" Çü½ÄÀ¸·Î ¸¸µç´Ù. ÇÑ Å×ÀÌºí¿¡ ¿©·¯°³°¡ ÀÖÀ¸¸é column_seq ·Î Ãß°¡ÇÑ´Ù. - user Å×À̺íÀÇ no ÀÎ °æ¿ì´Â user_seq °¡ µÈ´Ù. CREATE sequence tablename_seq INCREMENT BY 1 -- Áõ°¡Ä¡ START WITH 1 -- ½ÃÀÛ MAXVALUE 9999999 -- Á¾Á¡ NOCACHE -- NOCYCLE; 3. key °ª "PRIMARY KEY (no)" ´Â ±×´ë·Î ¼³Á¤Çصµ µÈ´Ù. 4. NOT NULL °ú DEFAULT ÀÇ À§Ä¡¸¦ ¹Ù²Û´Ù. ¼·Î ¼ø¼°¡ ´Ù¸¥°Å °°´Ù. - MySQL NOT NULL default '', - Oracle DEFAULT '' NOT NULL , 5. \\\' ³ª \\\" ·Î µÇ¾î Àִ°ÍÀ» '' ·Î ¹Ù²ã¾ß ÇÑ´Ù.