Question : I’m currently looking into an issue where when running MySQL prepared statement I get an exception: SQL Exception: […]
Tag: mysql-5.7
MySQL – when switching to a bette server lags
Question : I have 2 servers, Ubuntu 16.04 LTS, MySQL 5.7.21-0ubuntu0.16.04.1 – Freshly updated just in case. 64GB SSD drives […]
Returning 0 if value is NULL
Question : SELECT p.id , ig.NumReceived , og.NumShipped , coalesce( (p.StartingInventory – og.NumShipped + ig.NumReceived), p.StartingInventory ) as OnHand , […]
Is it possible to change between SELECT column based on an “IF” statement? and use INNER JOIN variables?
Question : I have a table of ‘mapped_products’: product_id | price A table of ‘product_id_to_name’: product_id | product_name (please don’t […]
How to enable failed login profle on MySQL
Question : We are trying to implement failed_login profile for account lock on MySQL. didn’t find it on documentation. Our […]
how to properly index a varchar column that won’t use LIKE
Question : I’ve been experimenting with EXPLAIN and noticed that the row count was big for our query so I […]
MySQL return rows ONLY if ALL the rows in another table have a specified value
Question : I have two tables Table1 : efd_details( id ) Table2 : efd_detail_status( detail_id , status ) Now the […]
Slow fetch time for MySQL query with large result set
Question : I’m aware I should expect slower fetch times for large result sets generally, but I don’t understand why […]
MySQL, comparison between, tables with not all records common, on 2 time intervals
Question : I want to make comparisons on the volume of sales, turnover and margin of all product sales between […]
MySQL5.7 (Windows) how to install from zip file without the Data Directory? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]