mysql-5.7 Questions
4
Solved
I have a table with JSON field which contains an array of JSON objects. I need to select objects by some condition.
Create and fill a table:
CREATE TABLE test (
id INT AUTO_INCREMENT PRIMARY KEY...
4
Solved
The statement is like SELECT * FROM db.table group by id desc;
Would raise an error like
15:02:24 SELECT * FROM db.table group by id
desc LIMIT 0, 10 Error Code: 1064. You have an error in you...
8
I installed MySQL community server 5.7.10 using binary zip. I extracted the zip in c:\mysql and created the data folder in c:\mysql\data. I created the config file as my.ini and placed it in c:\mys...
3
The company I am working uses an older stack, and I need to install MySQL 5.7 on my Ubuntu 22.04 LTS to work on some projects locally. Does anyone knows how to do this? I just can't find anything b...
Strident asked 5/8, 2022 at 13:8
3
I have mysql 5.7 with a denormalized table that has some JSON columns. I need to extract unique / distinct values per row for an array column.
For e.g: ["a", "b", "b", "a", "c"] expected output s...
10
Solved
I have a table customer that stores a customer_id, email and reference. There is an additional table customer_data that stores a historical record of the changes made to the customer, i.e. when the...
3
Solved
Whenever i fire this query from one of the mysql client (emma):
CREATE TABLE `tbl_mappings` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`private_id` int(11) unsigned NOT NULL,
`name` tinyt...
16
Solved
It seems that I may have inadvertently loaded the password validation plugin in MySQL 5.7. This plugin seems to force all passwords to comply to certain rules.
I would like to turn this off.
I've...
Laban asked 30/3, 2016 at 6:17
2
EDIT: I am seeing the same behavior in Python as PHP. Seems to be something with MySQL.
We are trying to upgrade from MySQL 5.7 to 8.0. Our codebase uses PHP MySQLi for queries to our MySQL server....
Dealfish asked 2/8, 2022 at 15:46
5
Solved
I have a MySQL 5.7 instance running without problems on Ubuntu 16, but when i try to install any other package or try to update existing ones through apt-get, i get the following error:
# apt-get ...
Wainscot asked 2/11, 2017 at 12:34
2
I am not able to extract quoted strings using JSON_EXTRACT function in MySQL 5.7.
Sample input:
{
"email": "d'[email protected]",
"body": "I may have "random quotes '(single)/(double)" " i...
1
Solved
How to use DISTINCT with JSON_ARRAYAGG?
Let's consider the below query as an example.
SELECT
staff.company,
JSON_ARRAYAGG(
JSON_OBJECT(
'uuid', UuidFromBin(staff.uuid),
'username', staff.user...
Avery asked 4/2, 2022 at 22:29
1
Solved
Facing Locking issues in delete query in mysql 5.7.18.
Mysql version - 5.7.18
Isolation level - READ-COMMITTED
Table structure:
mysql> show create table test;
+-------+--------------------------...
5
Solved
I am new to laravel and I am having an issue with DB problem.
I have disabled 'only_full_group_by' sql_mode by editing /etc/mysql/my.cnf file. And I checked sql_mode for both global and session us...
4
Solved
I used mysql 5.7.16 community and centos 7.
I'm following a video tutorial to install mysql:
wget http://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
yum localinstall dev.mysql....
3
Solved
MySQL 5.7 introduces a new file ibtmp1 for storing temporary data in InnoDB to increase the performance.
But I have noted that its size increases continuously. On my db server its sizes increases ...
6
I need a specific version of MySQL (5.7) to be installed on my MacBook with M1.
I'm trying to do that with Homebrew.
brew install [email protected]
The output:
We've installed your MySQL datab...
Epigenous asked 13/3, 2021 at 21:14
5
Solved
I have table say TEST(id INT, attribute JSON) in MySQL 5.7
When I try to query the table in Nodejs using mysql package as follows
con.query("select * from TEST where id=?", [req.params.id], funct...
2
Problem: MySQL's uuid() default collation does not compare to configured connnection collation.
I have a database + tables + fields created with charset: utf-8 and collation utf8_polish_ci.
The m...
2
I have a table names "campaigns". One of the columns is named "filter_apps" and his type is JSON
I have file rows and they just contain array of tokens like so:
["be3beb1fe...
2
Solved
Here's my code:
SET @poly =
'Polygon((-98.07697478272888 30.123832577126326,
-98.07697478272888 30.535734310413392,
-97.48302581787107 30.535734310413392,
-97.48302581787107 30.123832577126326...
Kannry asked 30/12, 2015 at 6:19
3
Solved
Recently, I decided to get a VPS server and host my own forums as we grew too big for your average shared hosting platform. I thought it would be easy to setup and get going, and it has been for th...
Calbert asked 3/8, 2017 at 23:52
12
Solved
I use in application MySQL 5.7 and I have JSON columns. When I try running my integration tests don't work because the H2 database can't create the table. This is the error:
2016-09-21 16:35:29.72...
3
Solved
If I have a MySQL table with a JSON column called numbers and a record that has [1, 2, 3] in that column (array of integers), how do I update that record to remove the 2 (so it becomes [1, 3])?
3
How to create index on sub-documents in Json data type in MySQL server?
I know we have to create a generated column from the base table and then need to index that column Virtually or stored.
But...
1 Next >
© 2022 - 2024 — McMap. All rights reserved.