错误提示:ERROR 1273 (HY000): Unknown collation: 'utf8mb4_0900_ai_ci'
是因为linux下MySQL版本不兼容导致的。
Continue reading
SQL Injection Prevention Techniques for Ruby on Rails Web Applications.
Continue reading
最近一个业务需求,数据量较大,且查询相当复杂。要针对查询语句测试性能,需要往数据库中批量插入1000万条数据,从而验证查询语句的可行性。
Continue reading
If you want to mock a large amount data, you may need to generate some random strings.
Continue reading
Recently, I met a sort problem on the null values, a record on sorted column is null, and this record always display on top even if the sort is asc or desc.
Continue reading