Question

将以下在Oracle中正常运行的sql语句转换为能在MySQL中正常运行的sql语句。

Answer 1

CREATE TABLE stu_score_ms.course (
cid char(10) collate utf8_bin NOT NULL default '' PRIMARY KEY,
clnum` char(10) collate utf8_bin NOT NULL default '',
cname char(10) collate utf8_bin NOT NULL default '',
credit number(4,2) default NULL,
capacity number(4) unsigned NOT NULL default '0',
tid char(10) collate utf8_bin default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
试试