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,025
questions
-1
votes
0
answers
12
views
Can't install mysql using brew I get CMake Error DWITH_EDITLINE=system, but missing system libraries
Mac OS Catalina 10.15.7
What I'm doing
running brew install mysql
then I get an error
`Last 15 lines from /Users/user/Library/Logs/Homebrew/mysql/01.cmake:
Debian/Ubuntu: apt install ...
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 "...
- 17
0
votes
1
answer
31
views
How to count the number of groups of events that are more than 20 minutes from each other?
Consider the following events:
+---------------------+------------+
| S | D |
+---------------------+------------+
| 2024-07-21 07:01:48 | 2024-07-21 |
| 2024-07-21 07:01:49 ...
- 1,359
-3
votes
0
answers
31
views
Associate multiple columns to one code ID MYSQL [duplicate]
I have two tables.
One called datospaciente and another called inventario
datospaciente has 10 columns: material1, material2 to ... material10. Each one has a code for equipment (values such as 123, ...
- 1
-4
votes
0
answers
36
views
'ion' instead 'selection' in MySQL [closed]
I am using PHP & Symfony with MySQL.
Whenever I try to type 'selection', it always saves to 'ion'.
If I try to fix it from the web, it says it's saved but shows actually 'ion'. Then I have to fix ...
-1
votes
0
answers
12
views
Access denied to connect to MySQL server via Mac terminal [duplicate]
I am an IT student and I have to use MySQL for a university project. I followed installation instructions very closely via YouTube. However, I am encountering an issue when trying to connect to the ...
0
votes
2
answers
39
views
Is it possible to query for all events within 2 minutes of specific events?
I can create a query to return specific events based on some criteria, but is it then possible to query for all events with a timestamp within 2 minutes of each of the events returned from the ...
- 1,359
0
votes
0
answers
9
views
MySQL Password Not Working using Homebrew [duplicate]
I've been using homebrew to start and stop MySQL, but, it randomly stopped working, and keeps giving the acess Denied for User 'root'@'localhost' (using password: YES).
I'm 100% sure the password is ...
1
vote
1
answer
28
views
Filtering mysql data using nested json_table returns "Incorrect arguments"
I'm new to mysql and I'm trying to filter some data. I needed more entires to be in one column, so I used the json format.
With the help of chatgpt I'm able to search for fine, but there's a problem ...
- 13
-2
votes
0
answers
33
views
SyntaxError: JSON.parse: unexpected non-whitespace character after JSON data at line 1 column 16 of the JSON data [duplicate]
So, I'm new to PHP and SQL. I wanted to select the highscore of the user on the database and overwrite the highscore variable with it, so it doesn't start by 0 everytime I reload. I already managed to ...
- 1
0
votes
0
answers
39
views
How to return the same value using for loop and mysql query in Python
I have a code with some variables and I need to find the same data from my mysql database.
from typing import Generator
from requests_html import HTMLSession
import pandas as pd
import numpy as np
...
-1
votes
2
answers
59
views
i want to display old orders first from orders table based one company and followed by another company like wise [closed]
+----------+------------+
| id | name |
+----------+------------+
| 1 | storeone |
| 2 | storetwo |
| 3 | storethree|
+----------+------------+
+----------+---...
- 11
0
votes
3
answers
48
views
Use and add the case statement into the select [closed]
I have a table where I want to add a new column based on the result.
If I create the following query it works correctly as all the tables appear plus a new call RESULT
SELECT ID,
CASE
WHEN ...
- 563
0
votes
0
answers
13
views
How to directly connect a kmp desktop app with mysql
We are working on a multiplatform app, for this KMP (Kotlin Multiplatform) has been used, the app is planned to be launched in three versions, IOs, Android and Desktop, in the desktop section, it has ...
- 288
0
votes
0
answers
34
views
Laravel passport slow query
Im using Laravel 10 (PHP 8.3) with MySQL database. The Laravel apps is deployed on server A, and the MySQL deployed in server B. For the first 3 weeks, the performance is awesome, but per today the ...
- 116