[Err] 1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
2016-07-01
SuccessKilled queryByIdWithSeckill(long seckillId);有问题啊,秒杀成功表里面应该存在(1000,phone1),(1000,phone2)这样的记录。是不是应该使用id和phone联合查询出秒杀成功的记录。不然就只有第一个人能秒杀成功,后面的都会异常。
2016-06-29
mybatis里面mapper映射的sql,如果要加单行注释的话,一定要在--后面跟一个空格啊,否则就解析失败了。
s.create_time as "seckill.create_time" --comments here
报错:
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL
s.create_time as "seckill.create_time" --comments here
报错:
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL
2016-06-24
http://www.mybatis.org/mybatis-3/zh/getting-started.html
2016-06-24