merge multiple tables together – Mysql
i seem to be a little confused on what to do. I have 3 csv files, each have the the common rows of name age and sex. First csv file shows the common data of the 3 and proceeds to…
How should my my.cnf settings be? Now is very slow – Mysql
I use VestaCP with apache, nginx and Mariadb 10.3 on Debian 10 with 2core CPU and 3GB RAM. main purpose: store on opencart with ~10k products (about 150 tables in SQL). Right now I got very long pauses on searches…
Handling intensive server-side tasks? Do I still use async/await in the front-end? – Mysql
How do I handle really intensive server-side tasks, that can take multiple minutes? It's a user-facing task, so the user can give me some data, and the server will then work in the backend. I am fairly new to this,…
When connecting to the mysql database, an exception appears
can anyone help me, I am trying to connect mysql database, the server details are entered correctly, but when I call the open method, the program throws an exception. I also used Server explorer, in this case the program sees…
How to get all duplicates row in MySQL
I have a tables companies and addresses and need to get all duplicated rows Checking columns is companies.phone_number and addresses.columns Table companies uuid name phone_number 5esd A INC. 667-784-343 6dcv B INC. 866-653-343 56js C INC. 111-222-333 tug8 D INC.…
how to get duplicate data from table with sql – Mysql
I have a table directors and need to get all duplicated rows Checking columns is name and phone_number Table directors uuid name phone_number 5esd ari 111-222-333 6dcv lee 111-222-333 56js poo 667-784-343 tug8 ari 866-653-343 I need these rows: uuid…
How to obtain a group membership time evolution from login date / logout date table in mysql
a newcomer to mysql here: I have a members table with Name, login_date and logout_date columns. Name login_date logout_date John 2004-01-08 00:00:00 2004-01-10 00:00:00 Mary 2004-01-09 00:00:00 2005-05-31 00:00:00 Frank 2004-01-12 00:00:00 2005-11-08 00:00:00 Nancy 2004-01-12 00:00:00 2007-10-13 00:00:00 Louise…
How to use Exist sql function in Linq – Mysql
var _query = _dbContext.CashVoucherDetails .Where(x => x.CreationDate.Date >= From.Date && x.CreationDate.Date <= To.Date && (x.Type == Common.TransactionType.CPV || x.Type == Common.TransactionType.BPV) && x.CompanyCode == BranchCode && x.DebitAmount > 0) .GroupBy(v => new { v.AccountCode}) .Select(g => new { AccountCode =…
How to find 7 consecutive non zero values in SQL? – Mysql
If we have a table of 15 columns, the first one is id, and the other columns have numeric data type, in MySQL or a similar languages, how can I find if the record have 7 consecutive non zero values,…
While the server is under more strain, queries become slower – Mysql
How can I improve the following query's performance while the server is loaded? I've created a combo index and removed the index from the table because it's not picking it up, but is there another way to do it? ,…