I have 2 tables: Airport and City Airport has, of course, its own ID, a name, and also a CityName foreign key related to the name of the city it is in. City just has a Name and an ID. How do I ...

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 ...

Пароль я использую настоящий, тут я его просто скрыл. Объясните мне пожалуйста, что я сделал не так? Вот сам скрипт: import pymysql try: # Подключение к базе данных connection = pymysql....

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 ...

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 ...

I'm using a table of approximately 1TB in a MySQL database. This table also has a monthly partition. We store the last two months of data in this table and regularly truncate the data from the ...

SELECT tt.trans_type_name AS transaction_type, trans.transaction_time, a.trans_action_name AS transaction_action_name, trans.transaction_notes FROM(SELECT Cast(...

We’re working with a user table populated from multiple SSO sources, and the data has inconsistencies that hinder generating standardized names. I need a persistent, automated way to extract and ...

I am designing a DB where basically parent can't exist without two children. E.g: Entity set Marriage, CAN'T exist without entity set Man and entity set Woman, but neither Man or Woman need Marriage ...

A user I'm supporting is getting the error. The user has grants to various tables in mydb, but when he tries to access them, he gets the error: Access denied for user 'myuser'@'myhost' to database '...

I have written a small Glue script that fetches some data between two dates, but I found that it scans the entire table instead of just the data within the specified time range. I also tried creating ...

So I'm uploading around 50MB into a longblob in a local mysql server. Using LoadFromStream, setting the param value is near-instantaneous but the execution of the UPDATE statement takes around 2 ...

I have a list which consists of numeric values. In Python, it is written as: [959, 3480, 9346, 8367, 2847, 8330, 6946, 9586, 9722, 2775] Or in the case of MySQL: create table testtb(n int); insert ...

I am learning SQL from a class online. I wanted to ask if it's generally best to use LIMIT in my queries to make them run faster, or at least until I have them tested and pulling the right data. If ...

I am trying to set up a development and testing environment for the software of my new employer. The data is quite complex and due to some shortcuts/bad architecture decisions of the company that ...