661,419 questions
1
vote
0
answers
10
views
Tkinter linked combobox populate by MySql data [duplicate]
I'm starting with python and trying to create linked comboboxes populate by MySql data where the second will be updated dynamically based on what is selected in the first.
The principle is simple you ...
- 11
0
votes
1
answer
23
views
MySQL Previous Results Query Returning Incorrect Values
I am using a query that I found on Stack Overflow to return a row in my table when a production counter resets at the start of a shift. However, it is also returning rows when the production counter ...
- 13
-1
votes
0
answers
28
views
How to clear screen in MySQL 9.1 Command Line Client? [duplicate]
I am using MySQL Community Server 9.1.0 Innovation (in windows 10) and trying to clear the screen in MySQL 9.1 Command Line Client using the following command :
system cls;
Similar question already ...
- 406
-1
votes
1
answer
48
views
Simply join 2 tables without condition and cross join, MySQL
table 1:
value
a
b
table 2:
value
c
d
e
I need to get this result:
value
value
a
c
b
d
NULL
e
So, it's like Simple join, when row from 1st table matches corresponding(by order) row in ...
- 31
-1
votes
0
answers
19
views
shared vs exclusive lock in sql for each isolation level
I am studying transaction in sql, i read about isolation levels. Got to know about shared lock(read lock) and exclusive lock(write lock).
As per multiple sources, exclusive lock can only be taken if ...
- 148
0
votes
1
answer
40
views
MySQL: get daily count of items which have a start_date and an end_date
I do have tours in a table which do have a start date and an end date, e.g.
id | start_date | end_date
1 2025-06-13 2025-06-13
2 2025-06-12 2025-06-17
3 2025-06-20 2025-06-21
4 ...
- 83
0
votes
0
answers
26
views
MySQL POINT and POLY not Representing GEO data
I need to store POINT and POLY fields that represent points and areas on an Image Map, not GEO lat/lng coordinates.
Because I'm not representing Geography does not make sense to use the ...
- 3,229
0
votes
1
answer
42
views
How to optimise large dataset query to file with Python and MYSQL
I have the below python script that is fed arguments to read and excute an sql file to write contents to a txt file, however I am currently attempting to optimise for running large datasets - for ...
- 173
-1
votes
1
answer
33
views
Fetching rows containing highest value, and previous highest in SQL
Example table:
User
Updated
Item
Status
Bob
1.4
Apple
Eaten
Bob
1.4
Orange
Moldy
Bob
1.3
Apple
Ripe
Bob
1.2
Apple
New
Bob
1.1
Orange
Ripe
Bob
1.0
Banana
New
I want to be able to search based ...
-1
votes
0
answers
44
views
Status of charset UTF8 / utf8mb4 in MySQL 8.0 and PHP 8.1? [duplicate]
My question is what is now the best way to specify the character set UTF-8 (the real, four-byte UTF-8) in MySQL 8.0 and PHP 8.1, and whether the examples below are specifying the real, four-byte UTF-8,...
- 471
0
votes
1
answer
25
views
django.db.utils.ProgrammingError: (1146, "Table 'test_db.sensori' doesn't exist")
i have this problem when i run my testcase with django and mysql.
when i run manage.py test i've got this error.
Found 1 test(s).
Creating test database for alias 'default'...
System check identified ...
0
votes
1
answer
34
views
Get last non null field in SQL row
I have been racking my brain trying to figure this out. I am not an expert in SQL by any means, but here's what I'm trying to do. I have a table in SQL where the Row is specific to a vehicle and the ...
- 3
0
votes
1
answer
45
views
PHP Export Two Mysql Tables Data To Excel Or CSV
I have two mysql tables in following format
Table 1 - Institute Basic Details (institute_basic_details)
id | institute_unique_id | institute_name | institute_city
1 ABCD1234 ...
- 2,385
-5
votes
0
answers
41
views
Why do I have both phpMyAdmin and MySQL Databases in cPanel? I only used phpMyAdmin locally for development. with Real life exmple please
I’ve been using phpMyAdmin locally for developing my project, and I’m now working with cPanel for hosting. I noticed that cPanel provides two tools for managing MySQL databases:
phpMyAdmin – This is a ...
0
votes
1
answer
34
views
Why is the value of trip_days coming out NULL, when it's being used to calculate DailyCostAverage and it's returning the correct number just fine
i have this procedure where i'm calculating the total cost and daily cost average of a trip depending on the number of days of the trip. i'm using DATEDIFF to calculate trip_days.
i'm just confused ...
- 1
1
vote
1
answer
72
views
Constraint violation inserting into parent table
I am learning PHP/MySQL and ran into this. I have combed through Stack Overflow, but did not find anything that helped me solve the issue.
This is running under PHP 7.4.27 / MySQL 8.0.21.
My original ...
- 21
-1
votes
1
answer
53
views
How to select records whose date difference falls within the desired range [closed]
There is a table like this ('work_planned'). Columns with dates, type DATETIME.
id
id_cat
wrk1_start
wrk1_end
wrk2_start
work2_end
54
5
2024-06-18
2024-06-20
2024-06-21
2024-06-24
58
6
2024-04-25
...
- 1
-1
votes
0
answers
30
views
Error on mysql when running from a jenkinsfile on a docker image
I am running a WSL on my Windows11. On top of that I have a Jenkins container with a Docker-in-Docker image, so when I am running my tests through the Jenkinsfile I can create a container with the ...
-1
votes
3
answers
52
views
what's the difference between "order by created_time desc" and "order by -created_time" in mysql [closed]
Normally, I would take them as the same.
why different performance ?
BY using mysql:5.7
For a table holds 10 million rows
-- order by created_time desc
id
select_type
table
partitions
type
...
- 128
0
votes
0
answers
20
views
Can I perform DELETE queries in a controller that works in a PUT request endpoint? [closed]
I might've not explained well the question above since I am pretty much a rookie working with Express js.
I have the following Route in my "barbershopRoutes.js" file:
barbershopRoutes.put(&...
1
vote
1
answer
30
views
In MySQL is it redundant to include id as the last field in a composite index?
Knowing id is the primary key...
Lets say we have an index in MySQL like
account_id / assignee_id / is_public
but the sorting of a query that needs this index is by id (the primary index)
changing ...
- 2,220
-1
votes
0
answers
7
views
nonroot user cant connect to mariadb server [duplicate]
I'm running mariadb 15 on ubuntu 22.04.
Until recently, my nonroot user could connect to the mariadb server.
This changed recently. I don't know why.
As a nonroot user, an operation like this:
'mysql ...
- 319
0
votes
0
answers
35
views
Auto delete functionality in inventory table => when the quantity for the item reaches 0
I am working on making a virtual pet site. For the database schema I have developed inventory functionality. The inventory is a bridge table between the item table and the user table. It holds the ...
-1
votes
1
answer
26
views
Why doesn't the mysql if function convert nulls?
I have a mysql database where some table uses the entity attribute value anti-pattern. I need to query that table and pull in attributes. I'd like to have them as booleans, i.e., where the left join ...
- 8,368
1
vote
0
answers
19
views
Saving Multiple CachedRowset row changes to Database
I am writing a simple program that updates records in a CachedRowset. For some reason it will only save a rowset with only one record. If the rowset contains more than one record when I iterate ...
- 11
0
votes
1
answer
31
views
issues when trying to rename a column and modify the datatype
I am having issues when trying to rename a column and modify the datatype. I can do it separately, but when I try to put them together it can't find either 'Year' or 'ReleaseYear'. It doesn't matter ...
- 103
-2
votes
0
answers
17
views
SQL Injection Testing on Login Form [closed]
I’m currently trying to learn and understand SQL injection techniques for educational purposes. I’m testing on a local vulnerable web app setup (using a lab environment, not a live site).
I’ve been ...
- 1
0
votes
0
answers
27
views
I am having a problem in MySQL connection in Python which I never had before [duplicate]
Traceback (most recent call last):
File "S:\Python\lib\site-packages\mysql\connector\network.py", line 733, in open_connection
self.sock.connect(sockaddr)
ConnectionRefusedError: [...
0
votes
0
answers
36
views
Double join on a SQL table
I have the following SQL table:
propals:
id
ref
1
propal_1
2
propal_2
3
propal_3
orders:
id
ref
1
order_1
2
order_2
3
order_3
invoices:
id
ref
1
invoice_1
2
invoice_2
3
invoice_3
...
1
vote
2
answers
19
views
org.hibernate.MappingException: Unknown entity: org.example.Person
I am trying to save a record of Person class into mySql database using pure java and hibernate but I get this error. these are my classes. I appreciate any help why this error is raised.
With these ...
- 92
-2
votes
0
answers
27
views
MySQL Error: 2005 (HY000): Unknown MySQL server host 'MySQL Server Address' (11001) [closed]
I am using MySQL Command Line Client to create a table to record my part-time job application history. The table is created successfully using the following SQL code:
INSERT INTO ...
- 1
-1
votes
0
answers
18
views
Access Denied Error When Connecting ASP.NET Core Project to phpMyAdmin Live Server After MySQL Export/Import
I'm working on an ASP.NET Core project where I initially used a MySQL Workbench local database. I exported the entire database with data from MySQL Workbench and then imported it into phpMyAdmin on my ...
-1
votes
0
answers
40
views
How to use MySQL database data with Odoo 18? [closed]
I am working on a management application that handles a large amount of data, and I currently use MySQL as the database. I am planning to transition to using Odoo for managing this application. ...
2
votes
2
answers
70
views
How can I force a WINDOW function in MySQL to show 'NULL' unless complete window frame is available?
I want to get moving sum and moving average on each date for last 7 days (including current day). I used WINDOW function and used ROWS BETWEEN to frame the function which calculates correctly, but it ...
0
votes
3
answers
36
views
How to Split mysql Column Data using JSONSTRING
I have a Column in MYSQL table with the following values
"acc":"0","alarm":"02","batl":"6","bats":"1","cellid":...
- 153
1
vote
1
answer
30
views
Top Reviewed Customers per Product
Top Reviewed Customers per Product
Using the table playground.product_reviews, write a SQL query to identify, for each product, the customer who provided the highest review score. If there are ties in ...
- 25
-3
votes
0
answers
19
views
Problem with Mocking a Product in Laravel [duplicate]
<?php
namespace Tests\Unit;
use App\Services\Shopify\ShopifyService;
use Illuminate\Support\Facades\Session;
use Illuminate\Support\Facades\Log;
use Mockery;
use Tests\TestCase;
use Shopify\...
- 15
0
votes
0
answers
31
views
SELECT * FROM my_table where match('ZS'); not worked in manticore
I have install manticore successfully.and my manticore config file is:
source my_source{
type = mysql
sql_host = 127.0.0.1
sql_user = test
sql_pass = iflytek
...
- 1
2
votes
1
answer
44
views
MySQL - trigger - limit update to one row
Beginner to mysql trigger, I do some searches but can't reach my objective,
I simply want to restrain an update query on a specific table to one row or cancel it.
For multiple raisons I have to do ...
- 23
0
votes
0
answers
49
views
How to stop a stored procedure in a mysql database after a IF is satisfied? [closed]
I have a stored procedure in a mySQL database with over a thousand lines, however, I want to set an IF right at the beginning so if its condition is satisfied the WHOLE procedure would stop after the ...
0
votes
1
answer
46
views
Cannot connect to remote MySQL server via connection string [duplicate]
I have a server running at let’s say 10.55.1.95 that runs MySQL database engine. I try connecting to it on a different server lets say 10.55.1.98 via a connection string like
sql_alchemy_conn=mysql+...
- 335
-2
votes
1
answer
41
views
Mysql is closing the connection on Ubuntu
Hi I built a MERN app (used mysql instead of MongoDB)
deployed it on the VPS (Ubuntu 24.04) everything seems okay but
when I try to check the logs of my backend using pm2 package it gives
me kind of ...
- 558
3
votes
3
answers
76
views
Get all tax rates within a given date range
I have a table with tax rates. Each tax rate has two date fields: 'valid_from' and 'valid_to'. 'valid_to' can be NULL, then the tax rate is valid until a later tax rate is inserted. Now I want to ...
- 607
-2
votes
0
answers
28
views
Python package intallation for mysql [duplicate]
try to install the Flask-MySQLdb package for python flask project. please help to fixed this error. Flask-MySQLdb
Collecting flask-mysqldb Using cached
Flask_MySQLdb-2.0.0-py3-none-any.whl.metadata ...
1
vote
1
answer
56
views
How to set a default value of 1 year from now for expire_at in Laravel migrations? [duplicate]
I am creating fields for a table in Laravel. I want to create a expire_at column using $table->timestamps() but set a default date of 1 year from now.
Currently, I am trying the following:
$table-&...
0
votes
0
answers
20
views
Innodb - Can you safely ignore the warning "Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size" [migrated]
We get this warning in our online shop
report.WARNING: Memory size allocated for the temporary table is more
than 20% of innodb_buffer_pool_size. Please update
innodb_buffer_pool_size or decrease ...
- 20k
-3
votes
0
answers
48
views
i am doing a project on AWS, i have encountered one issue related to the network connection [closed]
enter image description herei am doing a project aenter image description herend i have given access to the RDS data base to the instance and i have installed python and flask. when i given the ...
-8
votes
0
answers
39
views
How to connect a React frontend with a Node.js backend and MySQL database? [closed]
I'm building a full-stack application and need to connect my React frontend to a Node.js backend that interacts with a MySQL database. Here's what I want to achieve:
Fetch data from a MySQL database ...
-1
votes
0
answers
18
views
MySQL Query of Adding or Editing a Woocommerce Product [duplicate]
I wanted to link a product inventory database to a Woocommerce Database but I need to be working on a different app, that links these 2 databases.
I tried to be building a CSV file each day and ...
-2
votes
1
answer
46
views
Problem in creating multiple database using one mysql user? [closed]
In hpanal_hostinger hosting, can I add more than one database through one MySQL username?
