6 questions from the last 7 days
2
votes
1
answer
40
views
Parsing MySQL Client Handshake response message
I'm trying to parse the Handshake response packet from MySQL client/server protocol
For the task I'm connecting to the application via mysql cli client:
mysql --version
mysql Ver 9.5.0 for macos15.4 ...
- 379
-2
votes
1
answer
75
views
Showing exclusively the biggest value [duplicate]
I've been tasked with finding the client with the highest sum of payments, the table they gave me contains the customer number and amount, I have not been able to do this,
SELECT suma.customerNumber, ...
Best practices
0
votes
7
replies
95
views
MySQL SELECT … FOR UPDATE causing table lock during high traffic while generating sequential transaction IDs
I have a PHP + MySQL project where I need to generate sequential transaction IDs.
Each transaction can have multiple items, so all rows for that transaction must share the same txn_in value.
Tables
...
-2
votes
0
answers
70
views
Как подключить python скрипт к базе данных mysql на phpmyadmin? [closed]
Пароль я использую настоящий, тут я его просто скрыл. Объясните мне пожалуйста, что я сделал не так? Вот сам скрипт:
import pymysql
try:
# Подключение к базе данных
connection = pymysql....
- 1
-1
votes
0
answers
33
views
Dapper Mapping not working as expected. Using myql, asp.net core web api [closed]
I am fetching ProductTransfer table together with related products. Although the total records = 1200, am only getting three records returned by my api.
Here is my models
public class ...
- 37
2
votes
3
answers
144
views
What is the meaning of that Database is the highest levels in MySQL structure? [closed]
In the book Learning PHP, MySQL, JavaScript, CSS, and HTML5 – A Step-by-Step Guide to Creating Dynamic Websites (6th Edition), it says: “The highest level of MySQL structure is a database.”
What does ...
- 41