Questions tagged as 'mysql'

Tagged questions
2
answers

Problems in a query with related tables

I am not an expert in SQL and I have the following problem ... I have two "related" tables, one of products and another of product characteristics in which I keep values that these products can have, for example: colors, materials , sizes, etc ....
asked by 08.05.2018 / 08:54
0
answers

Sub SQL selections

I have to separate and group the results of a query by year and by location. Both sources of information are in the same table. If I use group by per year it combines all the locations, likewise the inverse one. I imagine that the solutio...
asked by 09.05.2018 / 21:51
0
answers

Android Studio jdbc and remote database on the internet

Well the reason for this post is to ask those who have already tried and / or those who are curious as I am. Well I am creating an android application that is used to execute SQL commands on a remote MYSQL server installed on a CENTOS7 platform,...
asked by 09.05.2018 / 23:00
0
answers

inner join in mysql update with last record

I have the following table, when doing inee join this take (or place) the first result that it finds and I want it to take the last, is there a way to force or modify my query? (when supertoken_id is dated 06/02/2018 and id = 1116741)...
asked by 09.05.2018 / 21:01
0
answers

How to get records (Time.Checked) Not used in another table in different fields (Time Input.Assistance or Time Out.Assistance)?

In an Assistance System I have the tables: Checks: IDEmployed HoraChecada DateChecked At the time of processing the check it generates me an Assistance only using TimeChecada I do not know the idChecada used for the table: Suppo...
asked by 08.05.2018 / 15:33
2
answers

HELP I can not send PDF in email from Database

I had a form that asked for mail and sent to a function that answered with information. Now I added a Hidden field in the form to send the path of the file via POST, but when I send it, it gives me an error:    Parse error: syntax error, unex...
asked by 08.05.2018 / 23:30
0
answers

Using DataFrame in Python

I have a data list that loads a DataFrame, on which mathematical calculations were made, but some of them are empty, is it possible to discriminate between them ?, I am currently using Python 2.7 and the Panda library.     
asked by 07.05.2018 / 21:20
1
answer

Problem in MySQL query that I can not identify

I am creating a search engine, for this I already have the query working, at the end of the query sent the parameter "LIMIT", because with that query I return the results and build the paging, however I have a probelama (precisely with the page...
asked by 14.05.2018 / 00:05
0
answers

Doubt about use of catch in Netbeans

I'm new when it comes to java and a doubt arose and I can not find anywhere to solve it. I'm doing a project to learn well how to use Netbeans and mysql. My question is the following: I am using a catch to show messages according to the error. M...
asked by 13.05.2018 / 22:21
0
answers

Chartjs with MYSQL and PHP

I followed this tutorial link to show graphics, I went well with the database and then to change to use with my database worked perfect in the same way, until one of the fields had the term "sugar" and the data file. php does not show anything...
asked by 07.05.2018 / 03:08