[DB] How to count all rows in MySQL query with LIMIT
A SELECT statement may include a LIMIT clause to restrict the number of rows the server returns to the client. In some cases, it is desirable to know how many rows the statement would have returned without the LIMIT, but without running the statement again. To obtain this row count, include an SQL_CALC_FOUND_ROWS option in […]
[DB] How to Disable MySQL Strict Mode
What is Strict Mode? Strict mode controls how MySQL handles invalid or missing values in data-change statements such as INSERT or UPDATE. A value can be invalid for several reasons. Why to Disable? If you do not disable the strict mode, you may encounter errors while using the script. How to determine the current global […]