java - [Microsoft] [ODBC Microsoft Access驱动程序]字段定义中的语法错误

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center。
                            
                        
                    
                
                7年前关闭。
            
        

我正在访问Java程序中的Access数据库，但是执行sql命令时出现错误：

static String SQLCreate = "CREATE TABLE CONTACT_INFO (" +
        "Contact_ID INTERGER NOT NULL PRIMARY KEY," +
        "First_Name VARCHAR(20) NOT NULL," +
        "MI CHAR(1)," +
        "Last_Name VARCHAR(20) NOT NULL," +
        "Street VARCHAR(50) NOT NULL," +
        "City VARCHAR(2) NOT NULL," +
        "ZIP VARCHAR(10) NOT NULL);";

我看不到任何错误，也许新的眼睛会有所帮助。
提前致谢。

最佳答案

你有错字用INTERGER替换INTEGER，它应该可以工作。

关于java - [Microsoft] [ODBC Microsoft Access驱动程序]字段定义中的语法错误，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/10764424/