python (12.9k questions)
javascript (9.2k questions)
reactjs (4.7k questions)
java (4.2k questions)
java (4.2k questions)
c# (3.5k questions)
c# (3.5k questions)
html (3.3k questions)
Why MySql Load_File(TextFile) return BLOB string?
Windows 7, MySQL 8.0, InnoDB.
File contains ususal text, load result contains BLOB string.
select load_file('d:/temp.txt');
result: 0x62...43
Why it happens? And can i get TEXT result whithout convert...
Tohares
Votes: 0
Answers: 0
MySQL 8.0 on Google Cloud SQL: How to set per-database permissions
I have a MySQL 8.0 database on Google Cloud SQL. I have two applications accessing two different databases on the same MySQL instance. I'm trying to set up access control so that each application has ...
fairport
Votes: 0
Answers: 1
MySQL 8 Mysqldump is slow after updating from mysql 5.1
We recently upgraded from MySQL 5.1 to 8.0.26. We are currently running the following command for our backup: mysqldump -F -A -R --source-data=2 --single-transaction -u $myuser -p$mypw -P 3306 -S /v...
stssub
Votes: 0
Answers: 1
How can I count same values in JSON found in MYSQL column?
I am collecting JSON data in MYSQL column.
I want to count numbers with same keywords in this JSON data.
Example JSON column:
id
column
1
{ "2": { "model": "Test Model...
Batuhan Polat
Votes: 0
Answers: 1