Questions tagged as 'mysql'

Tagged questions
2
answers

MySQL Find records that are not the same

Hello good day I have 2 tables that I show in the following image I used this query select a.rpu from costas a left join referencia b on b.rpu_ref = a.rpu where b.rpu_ref is null To have the result of search that the table that rp...
asked by 16.05.2018 / 18:33
1
answer

Error in Trigger "AFTER INSERT ON ..." from MySql

I'm having problems with creating a trigger in mysql, but I do not know why it's causing me an error. The table in which I want to insert once the trigger is activated is the following: CREATE TABLE 'reportes' ( 'id' int(11) NOT NULL, 'tip...
asked by 26.05.2018 / 07:50
0
answers

How can I store data from a datagridview to a MySql database?

I have a datagridview that is filled with student data according to a search made through a combobox preloaded with workshops in which students register. My question is: How can I insert only specific datagridview fields into the database? I...
asked by 25.05.2018 / 05:31
1
answer

How do I know which information in my query does not meet the WHERE parameter?

I would like to know in what way I can know which data is not met when making my query to the database from PHP . I mean I want to know in what way I can condition my code to know which parameter of the WHERE instruction is being...
asked by 22.05.2018 / 23:05
0
answers

Encrypt MySQL DB with certificate

Is it possible to encrypt a MySQL database with a certificate, so that only its content can be viewed on the server where the certificate is installed? The idea is to code the entire database at once, so that you do not have to modify query b...
asked by 23.05.2018 / 12:50
1
answer

Connection database in JSP

I am trying to connect to the database using JSP and in eclipse, but I get an error. I have imported the MySQL libraries, I have put connectors .. and it still does not work, this is the code: <%@page import="java.util.*"%> <%@page...
asked by 22.05.2018 / 21:16
2
answers

Program in Java does not connect correctly with MySQL in Ubuntu

I have a problem with my java program, because my program does not find the bd. this is my class connect here is all fine because sis is connected to My sql but when I make a query just throws me the message I can not actalizar that I have wh...
asked by 15.05.2018 / 04:49
1
answer

get the last major and repeated records without grouping mysql

I have a table id_periodo '| id_mesa 1 1 1 1 2 1 2 1 How can I select the last% co_of% greater? I was trying SELECT period_id, table_id FROM table where file_id = 1 ORDER BY peri...
asked by 17.05.2018 / 13:50
0
answers

Upload data from .json or MySQL with Highcharts and Ajax

I have a .json document that I keep with MySQL in my database and it contains the following: { "ticker": { "base": "BTC", "target": "USD", "price": "9330.81745211", "volume": "53283.57785327", "c...
asked by 07.05.2018 / 16:53
1
answer

Android studio - keep service connected to mysql

I would like to know how I can maintain a service connected to mysql from an android service and extract information. So far I make an HttpURLConnection towards a php file that makes the process, but only the service is executed only once, after...
asked by 08.05.2018 / 18:45