Questions tagged as 'mariadb'

Tagged questions
2
answers

SQL Query, join 4 tables, 2 group_concats + conditionals, Help

Hello, I have created a query sql to return all client data in a single query, this query works partially if all conditionals are satisfied, but this system uses soft delete, in which all the records can not be deleted and only marked as inactive...
asked by 01.07.2015 / 14:27
2
answers

Select Distinct is bringing duplicate data Mysql

Hello, I'm having problems with a query, and I need to bring only the last record of each id_face that has in the imagens table, but for some reason it's causing id_faces duplicates Follow my query: SELECT DISTINCT(...
asked by 04.12.2018 / 12:45
0
answers

Use INNER JOIN with WHERE clauses

I'm reassembling a system before in ASP now in PHP already with database loaded and mounted, however I need to do some filters where I need to fetch data from at least 3 different tables and maybe more later (But I'll review this database becaus...
asked by 23.11.2018 / 15:12
0
answers

Mysql has stopped working

Hello, I am using MariaDB 10.2, I ran the TRUNCATE command on a table with 4 GB and Mysql stopped working, I can not access any other database, I am using Mysql in xampp and it displays the following message :    2018-11-12 11:28:18 8748 [ERRO...
asked by 10.12.2018 / 18:42
0
answers

Performance FULLTEXT SEARCH (MySql) between multiple tables

Hello! I have a problem that someone here may have solved. First of all, I want to try an WITHOUT USING ElasticSearch solution or something. Come on: I have a bank with approximately 40 tables that have the same columns. One of these column...
asked by 20.11.2018 / 13:01
0
answers

Query in mysql grouped by hour

Good afternoon. I'm doing a query in mysql and it returns the precise values. My problem is to display values that do not return eg: I asked to group by hour or by day it only returns values that are data. Since values that do not have data a...
asked by 27.11.2018 / 15:54
0
answers

Mysql / MariaDb - Can not connect to local MySQL server through socket '' (111)

I have a program on Linux that runs quietly on a virtual machine with Ubuntu 14 and MySQL 5.5 . However, when you try to migrate to Ubuntu 18 and MySQL 5.7 , the program displays this message:    Can not connect to local MySQL server...
asked by 08.08.2018 / 04:45
1
answer

MMN Rank Query

Hello, I have the following problem: I made a micro-social network for managers, where initially the registration is done only by invitation, thus "measuring" the influence of each one. My problem is in the ranking that currently counts the invi...
asked by 10.07.2018 / 19:40
1
answer

Mysql above 5mil lines

Well, I'm developing a code that only came up with the following problem, when I performed a performance test with 5mil lines, it exceeded the limit of 30 seconds ... what could be wrong? $app->get('/receitagrafico/', function() use ($app) {...
asked by 14.06.2018 / 23:49
1
answer

MariaDB returns null with between dates

Has anyone ever had this problem after I updated MariaDB, it seems that it ignores the between ... On my server these schemas returns null do not know why. Has this ever happened to anyone there? The version of my mariadb is 10.2.14     
asked by 16.05.2018 / 01:35