从 MYSQL 中选择时出错 [英] Getting error in Select from MYSQL

问题描述

在 Select from MYSQL 行出现错误 ResultSet rs = st.executeQuery(fetch_title);

Getting error in Select from MYSQL on the line ResultSet rs = st.executeQuery(fetch_title);

错误消息:您的 SQL 语法有错误；检查手册对应于您的 MySQL 服务器版本的正确语法在第 1 行的:09:53"附近使用

Error msg : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':09:53' at line 1

String test = "27-May-2016 11:09:53";
String fetch_title = "SELECT title FROM competitor_analysis WHERE cron_date_time="+test+"";
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(fetch_title);

推荐答案

在查询的语音标记中结束您的约会.

Wrap up your date in speech marks in the query.

String fetch_title = "SELECT title FROM competitor_analysis WHERE cron_date_time='"+test+"'";

这篇关于从 MYSQL 中选择时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！