Questions tagged as 'mysql'

Tagged questions
1
answer

Problem with access to MySql database

I am learning programming and I am struggling with a problem in my web application. I have made the same application using SQLServer and I have not had problems but changing the connection string to make it work with MySql stops working. I am...
asked by 20.10.2018 / 08:27
1
answer

MYSQL number of variable columns

I'm trying to perform a query on mysql that shows me the following information. I have a table that registers the hour of income workers, I would like to take a date filter, for example from 2018-10-15 to 2018-10-31, the relation of the hours...
asked by 19.10.2018 / 22:41
0
answers

Retrieve deleted data in SugarCRM

I'm trying to recover cases deleted in Sugar and make a trace of which user I delete them. I'm not sure if the data still exists. I found this information, but so far it has not been very helpful: link - I can not get it to work. link...
asked by 27.09.2018 / 21:23
0
answers

Eloquent query does not bring me the record with the specific filter

I have tried to make a query that brings me all the articles that are in Active but I have not got any results. It always brings me all so the state is inactive and is what I do not want. These are the questions I have so far: First que...
asked by 28.09.2018 / 00:37
1
answer

How to make a mysql query for php graph?

I need to make a query in MYSQL, I have the following data COLUM1 FECHA PAIS 0 2018-11-13 0 2018-11-13 Reino Unido 0 2018-11-13 1 2018-11-13 Colombia 0 2018-11-13 1 2018-11-13 Peru 0 2018-11-13 0 2018-11-13 Espan...
asked by 14.11.2018 / 13:25
0
answers

java rmi UnmarshalException - Driver

I am trying to insert a consumer in a consumer table from my CreateUserController. From that CreateUserController class I get the attributes to save my consumer in the database. This is my CreateUserControler class import javafx.event.Actio...
asked by 21.10.2018 / 17:55
1
answer

ERROR 2002 (HY000): Can not connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Please help me, it happens that I am using a xampp environment in ubuntu and at the moment of starting mysql by console this error happens to me please please help me I would thank you enough !!     
asked by 22.10.2018 / 05:35
0
answers

Add values from different tables and select the highest result

Well I have the following problem Select the name of the employee whose salary plus the extra salary of his position is the highest. And these are my 2 tables:
asked by 22.10.2018 / 04:50
1
answer

Enter a data by database that only appears once for a particular criterion

Greetings to all! I have a question about the database ... I am a beginner in this and I would like to know how to solve this issue that I am commenting on. It turns out that I am creating a database for a task that I have. The case of the...
asked by 14.09.2018 / 06:12
0
answers

Sentence in MySQL to count the records entered per hour

I have a table called records with the following columns: I am trying to create a statement that allows me to obtain the total number of messages per hour and the total of classified by the status column and this grouped by the column s...
asked by 07.09.2018 / 22:36