Questions tagged as 'mysql'

Tagged questions
1
answer

save data to an arraylist of a resultset

I hope you can help me I am trying to make me return a list from the database through a resultset but I can not get it I hope you can help me thank you public ArrayList<BeanNivelLlenado> consultarNivel(){ ArrayList<BeanNivelLl...
asked by 09.06.2018 / 12:18
1
answer

discount value in different records

Buenos Dias please, if you can guide me. I have a table called pago where the client is and another detalle where are the payments that the client must make. I would like to know if the customer has in the table detalle 4...
asked by 09.06.2018 / 10:26
0
answers

Is there a problem in having +2000 events in mysql?

I need to create rows in the tables every so often, the way that occurred to me was to finalize Mysql EVENTS, but there must be more than 2000 events running, the execution intervals are at least 1 day and the largest operation What they do is i...
asked by 07.06.2018 / 16:15
1
answer

How do I make a query about another MySQL query with Node.js?

I have created a pool of MySQL module.exports = () => { return mysql.createPool({ connectionLimit: 10, host: 'localhost', user: 'root', password: '', database: 'gym' }); } I have also made a query that shows me results...
asked by 08.06.2018 / 17:03
1
answer

Sentence Error: SELECT, JOIN ON CASE

SELECT nombre , p.DetallePrestaciones, o.Salario from empleados AS e inner join ocupaciones as o on o.PkOcupacion=e.FkOcupacion inner join prestaciones as p on p.PkPrestaciones= (CASE MONTH(CURRENT_DATE()) WHEN 1 THEN 1 WHEN 7 THEN 2 WHE...
asked by 09.06.2018 / 00:31
0
answers

Can I use objects in a database?

I have a case that I do not know which is the best structure of the relational database. User ID Name Task ID Name I want the following conditions to be met A user can assign the task to another user I require th...
asked by 11.06.2018 / 16:55
2
answers

MySQL problem: Error 1215: Can not add foreign key constraint

I have two Foreigns Keys and I can not get them inserted, I get an error. Any ideas: mysql> create table Inscritos( -> id int(6) not null auto_increment, -> estudianteId int(6) unsigned not null, -> tutorialId int(6) unsigned not...
asked by 11.06.2018 / 18:20
3
answers

Verify if ID exists in another mysql table

I want to know how to identify if the id of a Table A exists in a Table B. I have the following structure: Table A Table B Within TABLE A there exists the id which may or may not exist in TABLE B. The idea is to suddenly re...
asked by 06.06.2018 / 23:42
0
answers

Problem with a query when doing a WHERE with dates

I have a problem and that is that at the moment I do the where with the date I do not know why, even though there is something in the database with the same date to which I do not get anything, so it always enters the if. The date of the vari...
asked by 11.06.2018 / 22:31
0
answers

Insert data from a JTextField to MySQL

I would like to be able to help me with links, information, etc. that will help me to recover this: I have a jtxtField that I want to enter the information of is to the database in MYSQL and I really do not know how to do it. I have the connecti...
asked by 11.06.2018 / 21:07