Questions tagged as 'mysqldb'

2
answers

Why is the result added twice when using SUM () with JOIN?

Hi, I have the following question and it is that the sum is doubled and I do not know why, it adds twice the result when using SUM() with JOIN in Mysql. Each result comes out double in INVERSION_VALOR comes out 492 instead of 246,...
asked by 05.11.2018 / 23:15
1
answer

WebService PHP MySQL make two queries

I have this WebService in php and MySQL and the intention is to do the $ query2 (which is an update) and then execute the $ query that is a SELECT. As I see in phpMyAdmin you are running the UPDATE, but the client is not receiving the SELECT....
asked by 02.10.2018 / 13:04
1
answer

Problem installing flask-mysqldb on linux 16.04

I was trying to install the flask-mysqldb on my Linux 16.04 device but I found a problem, even with a virtual environment: _mysql.c: 32: 20: error fatal: Python.h: No existe ese archivo o directorio . (myFlaskAppenv) mike@mike-thinks:~/P...
asked by 02.06.2018 / 14:48
0
answers

SQLSTATE [HY093]: Invalid parameter number: number of bound variables does not match number of tokens

I have been working for a while with php and sql in Object oriented programming and I just started using sql tables in this I get this error:    SQLSTATE [HY093]: Invalid parameter number: number of bound variables does not match number of to...
asked by 06.11.2018 / 22:30
0
answers

mysql in whiles?

I have a question that I would like to receive some help, well I would like to know if you can do a single while in php for several mysql queries or is it a while for each query? This to generate reports in excel with the help of the phpExcel li...
asked by 12.07.2018 / 17:16
0
answers

MySQL / Python - Reject queries if the database, table and column are not written within '(accent grave / backtick)

I would like to know if there is a way in which I can create restrictions when executing a query. What I would expect is that by having a query like the following: SELECT * FROM 'database'.'table' WHERE 'column' = 1; -- Notese los ' (acento gr...
asked by 12.03.2018 / 17:19