Now I have an English-Chinese dictionary database file (This database source file comes from this website and this file can be downloaded by clicking "点此下载". After downloading, you can rename it). I want to find out all the words whose second letter is
b. But I don't know how to access this database file:
Needs["DatabaseLink`"] conn = OpenSQLConnection[JDBC["SQLite", "英语单词词典数据库 mysql版.sql"], "Location" -> "C:\\Users\\Administrator\\Desktop", "RelativePath" -> True] SQLExecute[conn, "SELECT *b* FROM SAMPLETABLE"]
But the above code is invalid, I very much hope that you can provide as detailed help as possible, what should I do?