mysql - Java 中的 SQLSyntaxErrorException。奇怪的问题

Question

SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1 * FROM payments' at line 1

这是我遇到的错误。我不知道我的代码有什么问题。其他已经回答的问题不包含我的问题的答案。这是我的代码:

   public void getAuto() throws Exception {



        String q1 = "SELECT TOP 1 * FROM payments";
        try {
            rs3=st.executeQuery(q1); //here is the error
            String ppmail = rs3.getString("mail");

            String q2 = "Delete from tabela where ppmail="+ppmail;
            st.execute(q2);
            getData(ppmail);

        } catch (SQLException e) {

            // TODO Auto-generated catch block
            e.printStackTrace();
            System.out.println(e);
            auto.setText("End of records");
        }


        auto.setText("1000 realised");
        }

Answer 1

在 mysql 中你应该使用 limit 1

 SELECT * FROM payment LIMIT 1

根据您的评论，您的第二个错误与电子邮件周围的 missinhg 引号有关

"Delete from tabela where ppmail='"+ppmail +"';";