Questions tagged as 'mysql'

Tagged questions
0
answers

Save blank column in Excel CSV

I want to import an Excel CSV file into my database with phpMyAdmin. It turns out, that my table has to store 4 different fields. id , codigo , nombres , apellidos where: id: Is the ID of the table as a primary...
asked by 02.07.2018 / 18:59
0
answers

checkbox, jsp and mysql

Dear I have in the bd the following related tables region provincia and comunas cuerpo (cuerpo_id, cuerpo_nombre) asig_comunas (asig_comuna_id, asig_cuerpo_id) The issue is that I would like to be able to assign the...
asked by 02.07.2018 / 22:32
0
answers

Error in MySQL stored procedure with variable VARCHAR

The problem is the following: I have an SP in MySQL that receives a variable of type VARCHAR to make a query using the received variable and return a table, the SP worked, all I did was erase the database because I had some problems in some tabl...
asked by 27.06.2018 / 23:30
0
answers

Send coordinates from google maps to mysql

<script> document.addEventListener("deviceready",onDeviceReady,false); function onDeviceReady(){ console.log("listo"); } function getDatos(){ navigator.geolocation.getCurrentPosit...
asked by 27.06.2018 / 05:29
0
answers

migrate query ON DUPLICATE KEY UPDATE mysql to ON CONFLICT DO UPDATE SET of postgrest

I have the following MySql query INSERT INTO codigo_postal (d_codigo, d_asenta, d_tipo_asenta, d_mnpio, d_estado, d_ciudad, d_CP, c_estado, c_oficina, c_CP, c_tipo_asenta, c_mnpio, id_asenta_cpcons, d_zona, c_cve_ciudad) VALUES ".$da...
asked by 27.06.2018 / 21:54
1
answer

Capture the ID of my table by means of jcombobox

Food in several ways my jcombobox but to capture the data does not work with this code full cbo: public void fillprovider (JComboBox cboxprov) { String[] registros = new String[2]; DefaultComboBoxModel llenar = new DefaultComboBoxModel();...
asked by 26.06.2018 / 23:23
2
answers

Load data to a Java form from sql

I'm trying to load previously stored data in a bd to a Java form What I want to achieve is that by selecting a list from the combobox load all the corresponding data (name, age, phone) My problem: When selecting a rut from the list...
asked by 27.06.2018 / 04:32
1
answer

Show data from two different mysql databases on the same page

Good morning. I have that question, I have two tables, with 2 matches each, and I want to show on the same page the 4 matches that are in the different tables of the database. I use this to show my database: $sql="SELECT * from dpartid...
asked by 27.06.2018 / 17:39
1
answer

as with a button preload a text in a text box and with the same button generate the search in html-php-mysql

The problem is as follows, as with a button preload a text in a text box and with the same button generate the search in html-php-mysql. Try several options to send the "POST" but empty I can not load the English text in the text box with the En...
asked by 05.07.2018 / 16:45
0
answers

Store Date with Spring MVC and MySQL

I have the attribute type Date in a class and when I want to register it in MySQL with type date , I get an error and it may be due to the format of the date, but I do not know what to do. Class attribute:    private...
asked by 26.06.2018 / 01:06