摘要：MySQL does not support casting as a double. Supported data types for Cast() are:BINARY[(N)]CHAR[(N)]DATEDATETIMEDECIMAL[(M[,D])]SIGNED [INTEGER]TIMEUNSIGNED [INTEGER] 阅读全文

摘要：LAST_INSERT_ID自动返回最后一个 INSERT 或 UPDATE 操作为 AUTO_INCREMENT列设置的第一个发生的值. 参考这里The ID that was generated is maintained in the server on aper-connection basis.LAST_INSERT_ID是基于单个connection的,不可能被其它的客户端连接改变。可以用 SELECT LAST_INSERT_ID(); 查询LAST_INSERT_ID的值.Important: If you insert multiple rows using a single 阅读全文