mysql-5.7 Questions
7
I want to apply a where condition to relation. Here's what I do:
Replay::whereHas('players', function ($query) {
$query->where('battletag_name', 'test');
})->limit(100);
It generates the ...
Jettiejettison asked 17/10, 2017 at 8:16
14
Solved
Cannot login to MySQL database after fresh install with root ID and empty/no password like other older MySQL versions do.
Pegg asked 30/11, 2015 at 3:57
2
Solved
How to write a basic MySQL query that has a WHERE on a property within a JSON data-type field? I don't see basic where clause q for json fields on SO.
Something like this, but of course these dont...
0
I'm planning to update mysql from 5.7 to 8.0 in amazon RDS
Once i'm running util.check_for_server_upgrade() im receiving such errors for all my triggers
Trigger db_name.tbl_name.trigger_name does ...
Overlay asked 26/11, 2020 at 10:41
3
Solved
I ran a mysql import mysql dummyctrad < dumpfile.sql on server and its taking too long to complete. The dump file is about 5G. The server is a Centos 6, memory=16G and 8core processors, mysql v ...
2
Solved
I have started using MySQL 5.7.10 recently and I am liking the native JSON Data type a lot.
But I ran into a problem when it comes to updating a JSON type value.
Questions:
Below is the table fo...
Dermatoplasty asked 25/1, 2016 at 6:16
2
I'm trying to connect to MySQL server within Vagrant's version of Laravel Homestead, which runs MySQL 5.7.
I never seem to had any problems with it, but on my new laptop with Catalina I'm getting ...
Quintero asked 12/2, 2020 at 19:4
8
Solved
I wrote an installation script to change the root password with this SQL command:
UPDATE user SET password='*C563415623144561...' WHERE user='root';
This doesn't work on Mysql 5.7:
http://dev.my...
Willey asked 25/8, 2015 at 15:24
4
Solved
I would like my MySql query to return a JSON object that looks as follows:
{"name": "Piotr", "likesMysql": true}
This seems to be working fine when I do:
SELECT json_object(
'name', 'Piotr',
...
2
Solved
I'm using mysqld_safe to be able to create a password for my root user (under Ubuntu 18.04, it is not asked on the installation).
To start MySQL, I have done:
$ sudo mysqld_safe --skip-grant-tabl...
1
Solved
I have an old database, where some columns have comma separated strings stored like this technician,director,website designer
I want to convert them to a JSON array, so I can use the MySQL JSON ar...
Demarco asked 3/1, 2020 at 10:17
4
Solved
mysql> desc temp1;
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| value | varch...
Saffron asked 23/9, 2019 at 15:41
3
Solved
I'm working with a legacy codebase here that currently uses OLD_PASSWORD() as a simple hashing function. This codebase now needs to connect to a database running the newest revision of MySQL 5.7.
...
3
Solved
I have a database with one column that is JSON of strings (ex. ["ART","LIT"], etc.). I want to search it using json_contains.
However, when I try:
json_contains(\`column_name`,"ART")
It error...
2
Solved
I have a MySQL table authors with columns id, name and published_books. In this, published_books is a JSON column. With sample data,
id | name | published_books
----------------------------------...
Appurtenance asked 30/11, 2017 at 5:56
4
Solved
I'm still pretty new to handling JSON fields in MySQL. All the solutions I've come across deal with objects that have key/values; unable to find one that handles JSON arrays.
Anyways, what I want ...
2
Solved
Just took me 2 hours to troubleshoot an issue on my backend.
Cause was that of empty string being equal to space:
SELECT ' ' = '';
-> 1
SELECT STRCMP(' ', '');
-> 0 /* means equal */
Int...
Reaper asked 14/1, 2016 at 5:56
2
How to check my current data dictionary cache size?
FYI:
-> Data Dictionary cache - which stores open tables information. So that the data dictionary cache increases depends upon the number of o...
1
Solved
I'm trying to use MySQL 5.7 with Sequelize, and I want to use the JSON datatype for the attributes field on my users table to keep track of user attributes such as home_phone, mobile_phone, work_ph...
Florinda asked 4/4, 2018 at 20:2
4
Solved
Anyone have the inside scoop on when Homebrew will be updated to support MySQL 8's first general release (8.0.11)? I can't seem to find it by searching, but I bet someone here knows :)
Bicapsular asked 2/5, 2018 at 2:56
1
Solved
The issue is that ş and s are interpreted by MySQL as identical values.
I'm new to MySQL, so I have no idea which collations would view them as unique.
The collations that I've tried using which ...
1
We have MySQL 5.7 master - slaves replications and on the slave servers side, it hapens from time to time that our application monitoring tools (Tideways and PHP7.0) are reporting
MySQL has gone...
2
Solved
I can't run my tests on Travis CI because i can't find a way to setup mysql 5.7 in container.
I've found this gist https://gist.github.com/BenMorel/d981f25ead0926a0cb6d explaining a configuration...
Stricker asked 16/1, 2016 at 20:19
1
Solved
I have the following sql query that works fine using GROUP_CONCAT:
SELECT orders.created_at,products.title, o_p.qty AS qty,
(SELECT GROUP_CONCAT(features.title,"\:", o_p_f.value, features.unit) ...
2
Solved
I want to return an array of date time ranges of when a site is down.
I am using MySQL 5.7.
Table down_time
created_at user_id down
2017-12-15 14:50:21 1 1
2017-12-21 19:19:19 1 0
2017-12-25 22:...
© 2022 - 2024 — McMap. All rights reserved.