Questions tagged as 'mysql'

Tagged questions
0
answers

See table by date

I have a table that data is written as follows: ID CANAL VALOR DATA 25 10 50 2016-10-14 14:10:05 26 11 12 2016-10-14 14:10:06 27 10 51 2016-10-14 15:10:10 Both records are recorded hourly, so I need to look at them and sho...
asked by 14.10.2016 / 21:57
0
answers

Select last conversations by counting the unread messages in each conversation

I made a chat in NodeJS and I can already bring the list of conversations. However, I also need to bring the amount of unread messages from each conversation. Currently this query brings the total number of unread messages in all conversation...
asked by 14.10.2016 / 05:27
3
answers

Login problem with password in MD5

Login Form: <form id="1" name="1" action="pass.php" method="post"> <div class="login"> <input placeholder="Usuário" type="text" id="username" size="25" name="name" /><br> <input placeholder="Senha" id="pas...
asked by 14.10.2016 / 02:59
0
answers

Send value of an element that has a data-name

I have a form that has a <span> that works as a slider that you select a value and with it is sent an email. But I also need it to be sent to the database, and I can not make it happen. Form: <form class="form-carro" method=...
asked by 23.10.2016 / 22:34
0
answers

Specify table name using namespace in createQuery in Doctrine

I need to create a database query on a table whose name is order and can not be changed. I made the following query: $query = $entityManager->createQuery("SELECT sum(o.orderPrice) FROM \App\En...
asked by 23.10.2016 / 22:46
2
answers

Encrypted password verification

I'm having a hard time checking the login with Delphi with encrypted password in the MySQL database, I can do the registration and encrypt the password in the database through Delphi with the StoredProcedure that I cr...
asked by 05.11.2016 / 00:43
1
answer

Problem with authentication in PHP, returns PDO :: errorCode (): 00000

I have a problem to authenticate a website with php, when I put the data in the form it returns the error message that I enter if it crashed and another errorCode 0000 message in the login method. Apparently I did not find any syntax errors or a...
asked by 03.11.2016 / 03:19
0
answers

MySQL extremely slow using LOAD DATA INFILE

I'm posting this question here, but I've already researched Google, in StackOverflow itself, I already tested changing several variables, disabling the Foreign Keys, Indexes and I do not even know how to import better, but I do not really unders...
asked by 13.10.2016 / 14:24
0
answers

TIME field formatting

I have the following given in the 55:42:55 database and need to make it more readable in this way 2d7h42m how could I do this formatting?     
asked by 13.10.2016 / 14:45
1
answer

Error in the Change method - Java and MySQL

Java masters, I'm working on a college project, using MVC layers, and I'm having problems with the client-change method. When I click the Change button on the form, it sends a message saying that the client has changed successfully, but when sea...
asked by 13.10.2016 / 03:40