SELECT * from logininfo where userId=5 and day21>= 2012-12-0

来源：学生作业帮编辑：拍题作业网作业帮分类：综合作业时间：2024/04/29 06:37:24

SELECT * from logininfo where userId=5 and day21>= 2012-12-01 15:59:34.0
SELECT * from logininfo where userId=5 and day21>= 2012-12-01 15:59:34.0 其中
‘2012-12-01 15:59:34.0’ 类型是Timestamp ,‘day21’ 类型是datetime .但是运行报的是StatementCallback; bad SQL grammar 错误.mysql datetime 对应的java时间类型不是Timestamp吗?

SELECT * from logininfo where userId=5 and day21>= '2012-12-01 15:59:34.0'
时间那里,加上单引号.
再尝试一下看看.

SELECT name FROM [BookStore].[dbo].[user] WHERE userid=?AND SQL >select count(*) from Teacher where teacherCode=? and te SELECT COUNT(*) FROM Users WHERE Id={0} AND LoginPwd = '{1}' 英语翻译select top 4 * from shop_books where anclassid = (select select * from book where 1=1 select A,B,C,D=(select count(*) from 表 where c=a.a and b=a.b select distinct id from names where tid = 'AREACODE' And dsc if not exists(select 1 from sysobjects where type='U' and na select uid from T_TABLE Where num='3' and time between like select distinct A.* from A,B where A.id = B.g_id and A.fwzid $query = "SELECT * FROM student_info WHERE name = '".$login_ String sql = "select * from tb_consumer where account='" + a