Mysql和Oracle中用到的資料格式和資料結構

• ​​寫在前面​​
• ​​一、Mysql​​
• ​​二、Oracle​​

寫在前面

一、Mysql

和存儲引擎有關

CREATE TABLE t1 (i INT) ENGINE = INNODB;
CREATE TABLE t2 (i INT) ENGINE = MYISAM;
-- Simple table definitions can be switched from one to another.
CREATE TABLE t3 (i INT) ENGINE = CSV;
CREATE TABLE t4 (i INT) ENGINE = MEMORY;
CREATE TABLE t5 (i INT) ENGINE = ARCHIVE;      

隻生成了四個表，CSV的存儲引擎加載不正确，

二、Oracle