Questions tagged [mysql]
MySQL is a free, open-source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). DO NOT USE this tag for other DBs such as SQL Server, SQLite etc. Those are different DBs that all use their own dialects of SQL to manage the data. Always specify the exact version of the server in the question. Note that configuration/setup-related questions are off-topic on stackoverflow.
mysql
662,198
questions
0
votes
1
answer
20
views
How to merge multi schema data into single schema in mysql?
I have one application with multi-schema and single schema both running on differnt server.We use MySQL database with multiple schemas, each containing several tables, stored procedule and other ...
- 556k
0
votes
0
answers
5
views
Find records as And in MYSQL
I want find Students id that , must have (professorId = 3 And courseId = 4) And (professorId = 3 And courseId = 2) And (professorId = 5 And courseId = 8).
sometime these parenthesis is one or more ...
- 622
0
votes
0
answers
23
views
SQL Inner join with where clause works fast with one condition, but not when activeFlag is added
I have a query like
select C.customerId, C.firstName, C.LastName, R.IsActive from
Customer as C
Inner join Rider as R ON R.customerId = C.customerid
where R.rideid = 'xyz' and
R.rideareacode = 'abc' ...
- 556k
0
votes
2
answers
14
views
PHP variable from mysql query in form, when null
I have an html form used to edit a record in a mysql table.
In the case of editing, I prefill the form with the current values for the record as returned by the query, as below:
<INPUT TYPE="...
- 3,457
0
votes
0
answers
38
views
How to Use a Single INSERT INTO Statement for Multiple Rows in Python?
I’m currently working on a Discord Python bot where I loop through a list of ForumTags and generate an INSERT INTO SQL statement for each object to insert data into a MySQL database.
However, I want ...
- 767
0
votes
3
answers
1k
views
Extract date from UUID in MYSQL
I am trying to decode uuid in mysql to identify what are the digits contributing to prepare the date part .
For e.g. uuid ==> b54adc00-67f9-11d9-9669-0800200c9a66
What is the date part in the above ...
- 1,482
1
vote
2
answers
1k
views
Get ?? when taking chinese characters from excel sheet and exporting to mysql via vba
Let me preface this question by saying that I know that this subject is tackled from various angles in numerous posts. However, I have spent hours and hours on this and still cannot get it to work, so ...
- 31
2
votes
2
answers
19k
views
MySQL error 0: Retrieval of the RSA public key is not enabled for insecure connections
I need to set up MySQL database in my computer. I downloaded the Windows (x86, 32-bit), MSI Installer from here.
I run the installer. At the final stage, the installer reach Apply configuration stage.
...
- 1,415
3
votes
2
answers
2k
views
How to query a JSON column using the -> operator in MariaDB
I'm trying to get schedules comparing the JSON column data with following code in a Laravel project:
$schedules = Schedule::where('schedule_with->company_person', $contact_company_person->id)-&...
- 35.9k
0
votes
2
answers
79
views
My Search function isn't working when I search by name
so I've tried creating a Wordpress plugin that searches data in a different MySQL database and it works when I search by license number but when I search for any kind of name I get sent to a "...
- 44
25
votes
7
answers
117k
views
Disable secure priv for data loading on MySQL
I'm running MySQL 5.7 on a Windows 10 machine. I've read through all the SO threads on this topic and still haven't figured out how to get my data to load and get past this error:
Error Code: 1290. ...
- 94.4k
517
votes
28
answers
803k
views
Connection Java - MySQL : Public Key Retrieval is not allowed
I try to connect MySQL database with Java using connector 8.0.11. Everything seems to be OK, but I get this exception:
Exception in thread "main" java.sql....
- 793
2
votes
0
answers
59
views
Can't connect to MySQL server in Git-Hub Action
I installed MySQL 9.0 in the docker environment using mirromutth/[email protected] [1] in GitHub Action. I set it up in Spring project as follows.
File application.yml
spring:
datasource:
url: ...
- 33
2
votes
1
answer
5k
views
What are mysql.session@localhost and mysql.sys@localhost user accounts good for?
I freshly installed a MySQL instance and found it has two user accounts: mysql.session@localhost and mysql.sys@localhost in the result of SELECT User, Host From mysql.user - I didn't create those. Can ...
- 94.4k
13
votes
4
answers
30k
views
brew start and brew restart wont start service
I installed [email protected] using brew. After installing, I started the service using brew services start [email protected]. Checking using brew services shows its working fine.
In any attempt after the first ...
- 1