SELECT * from db_bankroll.T_FinanceRecord where user_id = '3uyutyut' ;user_id 为 bigint 数据类型
此时sql 可查询 user_Id =3 的数据
= 改为 like
SELECT * from db_bankroll.T_FinanceRecord where user_id like '3uyutyut' ;
正常查询
SELECT * from db_bankroll.T_FinanceRecord where user_id = '3uyutyut' ;user_id 为 bigint 数据类型
此时sql 可查询 user_Id =3 的数据
= 改为 like
SELECT * from db_bankroll.T_FinanceRecord where user_id like '3uyutyut' ;
正常查询