Questions tagged as 'mysql'

Tagged questions
0
answers

SQL - Create a match matrix

Good afternoon, This question would be the next step to the question asked in " Doubt in complex grouping sql " and that a solution was already obtained. I summarize it and indicate the new question. I have a table with tickets like this,...
asked by 10.04.2017 / 16:16
0
answers

ERROR 1045 (28000):

When I try to access Mysql in a mac with OSX Sierra and the following error appears as an answer:    ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using   password: YES I need help to move forward. Thanks...
asked by 09.04.2017 / 23:58
0
answers

Error PROTOCOL_ENQUEUE_AFTER_FATAL_ERROR

Good, I have a REST API made in NodeJS and ExpressJS and the problem I'm having is that after several hours without making any request, the connection to MYSQL is closed, then when making a request the connection is closed, I get that error and...
asked by 28.03.2017 / 20:50
0
answers

How to sort alphabetically raw grocery

As I can alphabetically sort a field by name alphabetically, the problem is that the data is saved in uppercase, lowercase, uppercase and lowercase, and when I call the table with grocery crud , Well, it turns out he does not order me for...
asked by 28.03.2017 / 23:02
1
answer

How can I update data from a multiple input select

I have a problem (I do not know how to do an UPDATE) when it comes to updating the student's file since it only changes the name and image of the student, and what I want to do is add or remove the courses in which it is enrolled from a multiple...
asked by 18.03.2017 / 23:36
1
answer

Add subgroups in MySQL when a column has a certain value

I have the following table: | start_date | end_date | sales | is_finished | |:------------------------:|---------------------:|:------------:|:------------: | 2017-03-24 09:11:00 | 2017-03-24 09:11:00 |...
asked by 25.03.2017 / 23:18
0
answers

Do stored procedure with a tour of another table

Good afternoon community. I am a beginner in this of the stored procedures, and I would like to know some way to do the following: I have these 2 tables: Balances saldoid|cuentaid|deudas|abonos|mes -------+--------+------+------+---...
asked by 14.03.2017 / 00:30
0
answers

Best alternative to Workbench [closed]

Good morning. Well, that's it, I'm starting with mysql with the Workbench handler, but it gives me the thorn of being an outdated softwate, I feel there must be a much better alternative. Any suggestions?     
asked by 15.03.2017 / 21:12
1
answer

Conxion with java to database of hostinguer

/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package parte_conexion; import java.sql.Connection; import j...
asked by 07.07.2017 / 19:42
2
answers

No value specified for parameter 10 when loading date from MySQL in JDateChooser

I am between the sword and the wall, I get the following error No value specified for parameter 10 when wanting to load the date stored in the DB in a JDateChooser. The error occurs when I load my product edit form, which I use the loadData...
asked by 08.07.2017 / 04:03