I have the following situation: A user can have maximum number of partnerships. For example - 40.000 Question: In case user wants to add a new partnership, how it will be faster to check the current number of partnerships ?…
I have two tables trades and payments whereas single trade may have 0...* (none or many) payments. I want to get the sum of all trade amounts and the sum of all associated payment amounts, for a trade belonging to…
I have a react table rendering data that I can get using axios from mysql database. Each table row has checkbox. I am able to check/uncheck all checkboxes using that checkbox in <thead>. I need to write code for the…
There are entity and on recording to database, record wrong data Code to record entity public function createTelegramUser($entity) { TelegramUser::create($entity); } Entity [entity] => Array ( [telegram_id] => 5403205983 [is_bot] => [first_name] => Belarus => dilshodbelarus [language_code] => ru [message]…
I'm currently using AWS Athena and I'm looking to convert a string field 'YYYYMM' to date (i.e '202208' to 2022-08-dd) and define the date (dd) as the last day in that month. I would first convert the string to date…
I have small web/mail server with apache/mariadb. Last week we changed some of the WWW code and to make it work I changed in php.ini line : max_input_vars to 5000 (now 4000, it was 1000 at the start) And it…
It is possible to list all values in n number of tables having same structure? Table: insert into t2 values(1,sam); insert into t2 values(2,tony); . . insert into tn values(1,jim); Output: 1 max 1 sam 2 tony . . 1…
I'm sure this is a bit dumb, but I'm very very beginner in MySQL so here I go. I have a table Items with id (primary key), category_id (index) and some more columns. One of the categories (category_id = 5)…
Using MySQL 5.7, I have a table of urls containing url_title, url_description, url_keywords Sometimes I just need to look in url_title, but sometimes look for something in all columns. Is it better to just create one index containing all 3…
I am trying to finish my graduation project which is a desktop application for database transfer. The application was made by C# WPF. I want to introduce a feature in the application which is Quality Assurance, and it should be…