这个压缩文件包含了2个.sql文件(还有1个sql命令参考),由MySQL Workbench生成,包含了144790个单词的释义、注音(少部分单词无注音)与例句,均来自必应在线词典。MySQL表的字段如下所示:
Field Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
word varchar(50) NO NULL
pronunciation varchar(100) YES NULL
meaning varchar(500) NO NULL
EXAMPLE_SENTENCES varchar(2500) YES NULL
create_time datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
update_time datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
1