Questions tagged as 'mysql'

Tagged questions
0
answers

How do I pull results in my database and data based on the filter and exits in an organized way? The following is an example

                              Filter                  Status                                      ALL                     Acre                     Alagoas                     Amapá                     Amazonas                     Ba...
asked by 23.08.2018 / 20:48
0
answers

Error in aws lambda function connecting to rds mysql

I have made a connection between aws lambda and rds mysql server, but when I go to test it returns me the following error: {   "errorMessage": "Unable to import module 'test'" } Do you know what this error might mean?     
asked by 23.08.2018 / 21:20
0
answers

Two declared cursor

I would like to leave two cursors declared at the beginning of the procedure DECLARE R CURSOR FOR SELECT C.CODIGO FROM TABELA1; DECLARE CONTINUE HANDLER FOR NOT FOUND SET done2 = TRUE; DECLARE aulas CURSOR FOR SELECT DISTINCT a.codigo FRO...
asked by 16.08.2018 / 19:50
0
answers

Get greater value in select sql in a grouping, using count

Hello. I'm doing a query to return the number of events performed by states. I am adding the events by adding the state table through the inner join and grouping by state. The data is returned, I know which state has the most event number, bu...
asked by 16.08.2018 / 02:37
0
answers

problems with REPLACE in decimal field in MySQL with Python3

In Python 2 I used the SQL query of the following form SELECT REPLACE(SUM(valor), '.', ',') FROM pedidos and the result was thus 1790394.95 But in Python3 I run the same query and the result comes like b'1790394,95 ' I'm using Python3...
asked by 16.08.2018 / 21:19
0
answers

PHP script to prevent two equal data from being registered (MySQL) [duplicate]

I'm developing a system for my school library and would like to know how to make a PHP script with MySQL database, which, at the time of registration, check if there is no registration with that CPF.     
asked by 14.08.2018 / 21:48
0
answers

mysql accent problem, which grouping should I use? [duplicate]

I am having problems with accentuation in my data stored in mysql I have already put grouping ut8_general_ci, ut8_bin and did not work. What should I do?     
asked by 22.08.2018 / 21:01
1
answer

How many tables will be needed in MySQL?

I'm starting a project that aims to manage student grade and grade. The information I need to store is: Total subjects (All subjects that the student will need to study) Matters in force (Matters released for the semester, ex 7) Notes...
asked by 14.08.2018 / 05:28
0
answers

How can I update a jframe after a given time [duplicate]

I'm trying to update a jlabel for a certain time because this same label will vary according to the database I tried to use thread, I studied about this same but I do not know if this would be the solution, I'm a bit confused about this class...
asked by 18.08.2018 / 13:30
0
answers

Join with three tables Laravel QueryBuilder

I'm trying to do a join with three tables I have a table with county code, a table with the name of the county and a table with the names of the states I need to get the name of the municipality of one table and the name of the state in an...
asked by 18.08.2018 / 20:14