一、【1136】Column count doesn't match value count at row 1

二、【1248】MySQL--Every derived table must have its own alias

每個(gè)派生出來(lái)的表都必須有一個(gè)自己的別名
一般在多表查詢時(shí)，會(huì)出現(xiàn)此錯(cuò)誤。因?yàn)?，進(jìn)行嵌套查詢的時(shí)候子查詢出來(lái)的結(jié)果是作為一個(gè)派生表來(lái)進(jìn)行上一級(jí)的查詢的，所以子查詢的結(jié)果必須要有一個(gè)別名。

Contrast.jpg

三、【1292】Truncated incorrect DOUBLE value: 'MChopin'

Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: 'MChopin'
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3513)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2046)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1964)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1949)
 at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:477)
 at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:165)