Questions tagged [mysql-5.6]
This tag is for the questions related to the version 5.6 of mysql database.
mysql-5.6
451
questions
0
votes
0
answers
36
views
PDO MySQL 5.6 Query Execution Timeout [duplicate]
Going through threads from 2009-2022 it doesn't look like there has been a real answer on getting a query to timeout in PHP from MySQL (5.6). The PDO timeout attribute is for the connecting, not the ...
- 5,415
0
votes
1
answer
24
views
Removing and replacing whitespace to hyphens in an html description in mysql in img tags
There are several image tags in a html description row there is a problem as the images uploaded had some spaces in between
for ex:
<div class="colUnitImg">
<img src=...
- 11
0
votes
0
answers
295
views
how do I modify docker-compose.yml to download mysql 5.6 for an apple m2 silicon running Ventura OSX 13?
I have a docker-compose.yml file that looks like:
version: '3'
services:
mysql:
image: dtr.s-9.us/mysql:5.6
restart: always
environment:
MYSQL_DATABASE: 'mydb'
...
- 1,929
1
vote
0
answers
51
views
Optimise query to return various Nth percentiles in MySQL 5.6
I have a dataset that contains the execution time for various api calls.
What I am trying to do is return a table that provides the execution time for various percentiles across different api calls.
...
- 11
-1
votes
2
answers
31
views
Update missing values in MySQL 5.6 table by selecting values from closest records with same id
Let's say I have a table with logs. The value of status column may be NULL and I would like to UPDATE this value by copying value from the log for same settingid which have non-NULL status and closest ...
5
votes
2
answers
3k
views
Suddenly cannot dump remote database: Unknown column 'generation_expression' in 'field list' [closed]
I've always been able to dump my remote database using mariadb-dump from the CLI. Starting today, I suddenly got the following error
mysqldump: Couldn't execute
'select column_name, extra, ...
- 304
0
votes
0
answers
129
views
datetime/timestamp problem with replication from 5.6 to 5.7?
I'm replicating from mysql 5.6.33 to 5.7.41. I have a table with a datetime field. If I understand correctly, between 5.6 and 5.7 the decreased the space a datetime field uses because it doesn't store ...
1
vote
2
answers
1k
views
list is not in GROUP BY clause and contains nonaggregated column in X2CRM
I have created a custom module in X2CRM. Then, I created a new record in that module and logged time using the Log Time widget. Ultimately, when I retrieve the same record by clicking on that record ...
- 368
1
vote
0
answers
20
views
How to find the table record difference after changing the ROW_FORMAT of mysql table
I want to migrate from mysql 5.6 to mysql 8 but got some warning related with maximum allowed size (8126) for a record on index leaf page.
so need to confirm whether data are safe after changing the ...
- 1,313
3
votes
1
answer
995
views
Mysql 5.6 to mysql 8 upgradation throwing warning message the row size is xxx which is greater than maximum allowed size (8126)
While upgrading existing mysql 5.6 to mysql 8 got the warning message logs in mysqld.err logs several times for each database
[Warning] [MY-011825] [InnoDB] Cannot add field abc in table dbName....
- 1,313
0
votes
0
answers
134
views
mysql prepared statement unable to execute. Getting error 1064 in prepared statement
Query is retrieving correct result but in Prepared statement getting error "Error Code: 1064. check the manual that corresponds to your MySQL server version for the right syntax to use near '...
- 1
-1
votes
1
answer
39
views
MySQl v5.6 How to exclude unwanted / incorrect rows produced after Joining two tables
I have two tables , I want to fetch correct data rows, but when I make a join in between incorrect extra rows are getting create. I want to exclude them.
Table T1
Employee_ID
Work_START
1111
10 Nov
...
- 1
1
vote
1
answer
39
views
Select last registered row from each group from two tables in MySQL v5.6
Could you please help me with a query I'm having issues with? I tried to seach for similar questions here with no success.
I have 2 tables which I need to join and get the latest created_date from ...
- 33
0
votes
1
answer
407
views
Will adding index solve lock wait timeout exceeded error
We have a table with 2 million + records. The records are inserted through two sources, from UI and from AWS lambda/step function. The issue is that when records are inserted/updated via lambda, DB ...
0
votes
0
answers
8
views
What should be ideal value of Filtered column in mysql explain clause? [duplicate]
As per MySQL manual
rows shows the estimated number of rows examined and rows × filtered /
100 shows the number of rows that will be joined with previous tables.
in my case i have executed one ...
- 1,313