Questions tagged as 'mysql'

Tagged questions
0
answers

Port from wan to lan in firewall pfsense does not open

Hi, I'm trying to open a port through the pfsense firewall, but everything I tried and solutions that I found out there did not work for me. My intention is to give access from the wan to a server that is in the lan in a port, that is, as we wou...
asked by 24.05.2016 / 14:00
1
answer

Is there a better way to filter results with PHP / MYSQL?

Basically I'm starting with PHP by doing a small web search engine with a database that has some products. My doubt comes, good I want to get the user to put any word I throw all the results that are related to what was entered , I did it...
asked by 19.09.2018 / 13:03
2
answers

problems with mysql and php dates

Greetings I'm trying to make an application for personnel control more than anything to be able to keep in what date I enter and in what date its contract ends and to keep its date of birth I have found much information on the datepicker. It...
asked by 04.06.2018 / 21:50
1
answer

when I save information in the table it only appears in the database and in netbeans it appears as a new column

Frame room import Datos.vhabitacion; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; import primero_lo.fHabitacion; public class Habitaciones extends javax.swing.JFrame { public Habitaciones() { initCompo...
asked by 20.06.2018 / 18:49
1
answer

Capture ID with php and mysql

How to capture ID of a table with prepared statement in php and mysql to assign this Id that was captured and add it through a insert as foreign key of the following table. here the code: <?php //Tabla Cliente $...
asked by 20.07.2018 / 00:40
2
answers

1 Duplicate results with INNER JOIN

Thanks for letting me register here. In this opportunity I am a programmer of a new social network which took a day with only one problem. I have 3 tables and of the 3 tables one is duplicating me the images or tripling. <?php...
asked by 26.07.2018 / 00:14
2
answers

inner join repeats the data

Hello, good morning everyone, guys consult, I'm involved with a query, I need to show data from 3 different tables, I get it, but I repeat the data (rows), I have given several turns and I do not give the drama hehe , someone sees something stra...
asked by 30.07.2018 / 17:08
4
answers

because it is the error java.math.BigInteger can not be cast to java.lang.long?

I am trying to connect a web service application with MySQL but when I want to connect MYSQL server I get this error.              
asked by 14.04.2018 / 19:28
2
answers

GROUP BY in SQLServer does not work the same as in MySQL

Let me explain: When I make a GROUP BY with MySQL, I can select fields that can not be grouped, as descriptions (varchars), and the result shows, of all the grouped values, the first one that I find. But now I find SQL Server and it tu...
asked by 26.04.2018 / 22:29
0
answers

how to insert record repeatedly

I would like your orientation, I'm doing an insertion to my database of images that I upload, everything inserted very well, only that I do not repeat the name of this image entered the same number of times as the images entered. What can I b...
asked by 04.06.2016 / 12:49