[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聯(lián)合查詢出秒殺成功的記錄。不然就只有第一個人能秒殺成功,后面的都會異常。
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