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
661,892
questions
-1
votes
0
answers
10
views
Remove unreferenced records from database
I have 3 tables in a MySQL database
user
--------------------------------------
user_id, (PK)
email
agreement_user
--------------------------------------
agreement_user_id, (PK)
user_id, (FK user....
-2
votes
0
answers
18
views
Need to finalize the solution with SQL code
The problem is that for some reason my cat is not working correctly and I don’t understand the reason for this
I think I took into account all the conditions
Could someone please help me with the ...
-1
votes
0
answers
10
views
Why I am getting Missing From Keyword error in the following code?
The cancellation rate is computed by dividing the number of canceled
(by client or driver) requests with unbanned users by the total number
of requests with unbanned users on that day.
Write a ...
0
votes
2
answers
26
views
syntax error, unexpected string content "", expecting "-" or identifier or variable or number
In a PHP application I am trying to the users information from the table like below
session_start();
$sql = "SELECT * FROM users WHERE company_id = $_SESSION['companyId']";
$result = $...
-1
votes
0
answers
20
views
ER_BAD_FIELD_ERROR in SQL
CREATE DATABASE IF NOT EXISTS RAIL;
USE RAIL;
CREATE TABLE IF NOT EXISTS train (
t_id INT NOT NULL AUTO_INCREMENT,
t_rating INT NOT NULL,
t_name VARCHAR(20) NOT NULL,
t_price INT NOT ...
0
votes
0
answers
18
views
ER_NOT_SUPPORTED_AUTH_MODE Error even though mysql2 is being used [duplicate]
I am receiving an error
ERROR [ExceptionHandler] ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
every time I try to ...
-4
votes
0
answers
30
views
Best practice for file management in webb app (jQuery, js, php, mysql) [closed]
I have since many years developed a fairly simple webb app based on jQuery, js, php and mysql. I am looking into allowing users to upload files and access the files (download, remove, change name etc )...
0
votes
0
answers
10
views
MySQL 8 cannot drop a database or table due to an error stating 'dictionary object id does not exist'
I am unable to drop a MySQL8 database or table as it is giving me the following two errors. Despite searching online, I have not found any solutions to similar issues. Is there any way to proceed with ...
0
votes
0
answers
25
views
PHP Insert with Select and combining bound parameters with select values [closed]
I have a puzzle I'm trying to figure out. I am trying to creating an insert with select query to run once after looping to gather the information. This is using procedural php.
With the help of loop/...
1
vote
0
answers
13
views
Go MYSQL Connection pool behavior
I have an app which uses MySQL connection pooling. I am using the standard database/sql package. During app startup, I create the connection pool and set the following options on the pool
pool, ...
-2
votes
0
answers
18
views
Hosting Service for HTML, CSS, JS, Node.js, and MySQL Project [closed]
I have developed a fully functional website on my local machine using VS Code with HTML, CSS, SCSS, JavaScript, Node.js, and MySQL as the database. Now, I want to deploy this website on the internet ...
-3
votes
0
answers
15
views
WHY IS 'DELIMITER' NOT WORKING IN MYSQL WORKBENCH Mac OS [duplicate]
I use a macbook pro(not sure if that's why it's not working) and i am currently learning how to create stored procedures in mysql, my tuutor use the DELIMETER FUNCTION and **it changed colour to green ...
0
votes
0
answers
13
views
Delay problem in python/mysql integration
I'm making a python interface that has a user registration and login part using Mysql. I made a class to register and another to perform the login which worked normally, then I tried to apply ...
-1
votes
2
answers
47
views
Convert multiple MYSQL rows to only one array column
I have a simple database with the user and the country tables.
Which user belongs to only one country.
Which country has a list of users.
Right now Im using group_concat (code below) and its working ...
0
votes
1
answer
21
views
Docker volumes and MySQL data access
I am currently writing an automated check-in system in flask with a MySql database. I want the code to run indefinitely, so I've deployed the app and database on Docker. This way I can keep iterating ...