Questions tagged as 'mysql'

Tagged questions
0
answers

Get mysql time

Good mates I have a small problem, I have a sensor connected to mysql, it sends data perfectly, I have a timestamp and it does it well, what I have to do is create another column where I just set the time, HH: MM: SS only time, since the timesta...
asked by 21.09.2017 / 14:35
2
answers

Help if I do not find value in the table

hello friends I have a table catalog id codigo descripcion 01 12345 envase 02 12346 caja and an inventory table id codigo descripcion marca 01 12345001 envase dplast I am making a new inventory entry...
asked by 19.09.2017 / 20:53
2
answers

Insert 2 primary key of 2 tables in a third one that goes to relational

I have 2 tables. Company Table and Table Categories Both tables would not be related initially, but then we need to create a third table. Table category x company. The query must dump all companies and all categories to the third tab...
asked by 21.09.2017 / 16:59
0
answers

What do you think about the structure of this mysql table?

I wanted to consult your opinion about this structure of tables that I found coming from a known developer, then the structure CREATE TABLE 'tabla' ( 'C0' int(15) NOT NULL, 'C1' varchar(500) NOT NULL, 'C2' varchar(500) NOT NULL, 'C3' v...
asked by 12.09.2017 / 22:06
1
answer

Obtain age based on date in bbdd

Dear, I want to save a date of birth from form with jsp, then save it in bbdd mysql and then get it from the bbdd and calculate the age. Any idea how to achieve it? Greetings. <form action="cPaciente" method="post"> <label style="colo...
asked by 13.09.2017 / 21:22
1
answer

Backup of cpanel I can not open it in local xampp [closed]

I am making modifications to a page that is in production, I wanted to download a backup to edit it in development and I have tried to upload it in xampp but it gives me many errors with the database. I have already created the data base and I h...
asked by 25.09.2017 / 15:36
1
answer

JButton to connect to a BD

JButton Conectar = new JButton("Conectar"); in my main class. I would like that button to execute another class that I have in the package. SaveDB inside contains the Connection method. I tried this but it does not work. GuardarDB d...
asked by 25.09.2017 / 02:49
1
answer

concatenate three fields in listbox

I tried to show the list of users in a listbox, but I have not managed to make it work. If I just want to show a field like the name, it works fine, but I need to show the name and the two surnames. <?php class mHorarios extends CI_Model...
asked by 12.09.2017 / 12:35
1
answer

Trigger is not recognizing me the values sent by NEW

The fact is that I am making a trigger to act as a mirror in another table, however it is not working as it should. Here I leave the trigger: CREATE TRIGGER new_loaner_added AFTER INSERT ON 'total_loaner' for each row begin INSERT INTO Nu...
asked by 12.09.2017 / 15:11
1
answer

Move data between classes

Hello to all good afternoon, I would like to help me know how I can develop my idea. I have some lists in a class I did to make the connection to a database. which is the following: package pkgfinal; import java.sql.*; import java.util.LinkedL...
asked by 12.09.2017 / 18:11