Questions tagged as 'mysql'

Tagged questions
0
answers

MYSQL SELECT DISTINCT query does not work in MYSQL 5.7.21

In the previous MySQL version of the hosting this sentence worked for me without problems: "SELECT DISTINCT Mes FROM recogida ORDER BY ID DESC" Where the column ID is unique code for each entry in the table and Month is the month + y...
asked by 02.10.2018 / 16:34
1
answer

JcomboBox returns Null Pointer Exception

I'm doing a project to send packages in Java and I'm having a problem loading a combobox with data brought from a database. In the stack trace I am returning as error what can be seen in the image, and according to what I observed the line 239 t...
asked by 04.09.2018 / 05:16
0
answers

convert mysql query to django

Guys! I have this query that I want to use in Django and I can not find a way to do it. I hope you can help me: SELECT herramienta_id, SUM(cantidad) FROM inventario_transaccion WHERE carrito_id=1 GROUP BY herramienta_id What I want to do...
asked by 25.07.2018 / 01:18
1
answer

search in datagridview with a textbox

guys I have the following problem: I should look in a datagridview column if the value of a textbox is in one of the rows of that column, if the value coinicde, I should show a message that the time is occupied, otherwise , unlocks some controls...
asked by 03.09.2018 / 15:49
1
answer

How to make an INSERT of an Array

Very Good ... The query is made to the db, this query only shows the income ids that are in table 1 called (INCOME) and are not in table 2 (BILLING) a chuekbox was placed where the user chooses to which of them will enter the invoice code, en...
asked by 24.07.2018 / 19:12
1
answer

syntax mysql procedure

Could you please help me with the following procedure in mysql? ... The following procedure is in sqlserver. I would appreciate if you would indicate what it would be like with your syntax. I would appreciate your help please, I am suffering day...
asked by 21.07.2018 / 17:42
0
answers

Get data from MySQL to JTextField Java

I'm trying to get data from my db and display it in TextField's, my problem is that you only get the values of the first table in my list, when you select the second, they are not updated I charge it with MouseClick This is the first fie...
asked by 08.07.2018 / 06:11
1
answer

Databases in CodeIngniter

I'm starting with CodeIgniter and when I make a simple query to the database, it sends me the error that it is trying to access loclhost and not localhost. I already checked the database configuration and the host name I get localhost. $db[...
asked by 07.07.2018 / 02:58
3
answers

how to pass scrip variables that interpret a sql statement?

Good is the first time that I participate I am wanting to make the variables: xco, xto, xde, xcc recognize me in the query sql q I do below in vsql, it will not be possible if you can give me a hand or some idea to be able to find that way, than...
asked by 15.07.2018 / 20:53
1
answer

inner join repeated data (mysql)

Hello people, good afternoon, I have to take data from several tables (related to each other), it brings me the data I need, but it repeats, I have given it several times and I do not see where the fault lies, my query is so: SELECT c.idCita,...
asked by 16.08.2018 / 17:29