findnerd.com

Count number of rows and fields in a result set using MySQLi functions

In my previous articles we learned how to perform CRUD operation using MySQLi Procedural and Object Oriented style. On performing CRUD operations, the data of MySQL table are affected. This article ...
GitHub

Row limit based on display column MySQL

While creating an app using MySQL database with many relationships, querying budibase backend seems to be broken. Behaviour of returned request depends on... 'displayed column'. I have 5 rows in ...
GitHub

Mysql INT(10) unsigned column to row.getLong throws exception

INT(10) unsigned in mysql has limit up to 4b+ and when use with getLong of row, it throws java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.Long. Java's integer is signed and ...
Ars Technica

MySQL - simpler syntax to search multiple columns?

SELECT * FROM `the_table` WHERE `field1` LIKE 'string%' OR `field2` LIKE 'string%' OR `field3` LIKE 'string%' OR `field4` LIKE 'string%' OR `field5` LIKE 'string%' OR `field6` LIKE 'string%' OR ...