Questions tagged as 'mysql'

Tagged questions
0
answers

error in java when saving data in mysql database

The following question is already answered and I leave the code for someone else to work with her. This is a code to connect a java program to a MySQL database to save, edit, delete and more things to the table in the database. I have it in 4...
asked by 02.08.2018 / 16:24
1
answer

How to validate the following month by means of periodicity?

I have 3 selects the first select I choose the periodicity that I bring from a table can be bimonthly or biannual the second select I have the months also brought from a table and the third select same contains the months but it is only readonly...
asked by 02.08.2018 / 17:59
0
answers

Display Data in JTable with SOS parameter !!!

Hello guys, greetings from before anything. this time I need your support in a method I'm doing. I'm joining an inner join but no mysql tells me that the syntax is not correct the method shows me the data in a Jtable and search according t...
asked by 31.07.2018 / 18:53
1
answer

Exists == or === in MYSQL

I have looked for the question, to see if something appears about it, but I think I have not seen it, if so, I apologize in advance. The point is the following, I have a query in mysql where in theory I should show 2 values, otherwise, do not...
asked by 31.07.2018 / 18:08
1
answer

How to store the sum of the values that are entered in mysql and php

Good day! I commented: I have a table called "products" and I want to add the values that are entered in "$ amount" in a column that is called "$ total". This to keep track of the available stock. I have the following code: function agregar_to...
asked by 30.07.2018 / 12:41
1
answer

registry update problems (ondelete on update)

Hello good afternoon to all, again consulting you the following: I have a table (citations) in which I need to store a series of IDs from other tables, including the idRegistration of a doctor, and the idRegistro of an official, the insert ok bu...
asked by 31.07.2018 / 17:44
0
answers

Save several files in zip with php

I have a site that downloads a DB to an excel file and they suggested that I do it with a zip file, so I was thinking about downloading each table in an excel file and putting everything in zip, this is the code with which I create the excel...
asked by 31.07.2018 / 20:40
1
answer

How to speed up the search time of a MYSQL with PHP

I'm doing some statistical graphs, which I extract from a table that presents 30,000 records and I will show them in graphics (HIGHCHARTS) ... it turns out that when I make the first query to complete the options of my select, it takes around 20...
asked by 31.07.2018 / 21:10
0
answers

Error importing sql files to phpmyadmin

I need your knowledge to know what I'm wrong with. I'm new to programming and I'm starting to build structures with Mysql Workbench and then export it to phpmyadmin to work it. At the moment of importing the generated file in mysql worckbench I...
asked by 25.08.2018 / 18:18
1
answer

ERROR SHOWING DATA MySQL (ONLINE) IN LISTVIEW

I'm carrying out an application to show some wines, and I have an error that after researching many sites I can not understand. The fact is that it does show me the data, but with a "click" of delay. That is, the first time I click, it does not...
asked by 01.08.2018 / 12:06