Questions tagged as 'mysql'

Tagged questions
2
answers

Count function - Mysql

I have the following tables: times - time_id INT - time_nome VARCHAR rodadas - rod_id INT - rod_rodada INT - rod_pontos DECIMAL (10,2) - rod_fk_time INT I need to add punctuation and group by time.     
asked by 18.05.2017 / 19:09
1
answer

Display MySQL inside modal

I'm developing a new ordering system in PHP that works as follows: The user uploads the requests, which are stored in a MySQL table called requests ; After uploading, the user can change the status of these requests through script in...
asked by 27.05.2017 / 03:08
1
answer

Make a START TRANSACTION not reserve the ID of the tables involved, in case of failure in the insert

Hello developer friends, I set up a transaction script to insert values into 2 different tables, I put a or die at the end of each INSERT so that the data insertion does not occur in the second table , if an error occurs when inserting th...
asked by 30.05.2017 / 17:46
1
answer

Cost of processing between code and database

Among the many forms of development, there was a doubt about what will consume more of my processing between the same operation in different ways ... If I have a function that can be done directly in my database (a insert using a se...
asked by 27.04.2017 / 20:55
1
answer

is there any way to do multiple mysql queries and if one fails to undo all?

I wonder if mysql has some similar feature. I need to create an application and it is necessary to ensure that all sub queries succeed.     
asked by 27.04.2017 / 00:16
3
answers

How to change page content according to the end inserted in the link (URL)?

I have a user registration system. The person inserts some information like user, photo, name, a brief personal presentation, phone, and email. An id is automatically generated for each new entry. Until now it is already running correctly. I...
asked by 03.03.2017 / 06:46
2
answers

Sum of values taking into account 3 fields of the table

I have the following table quotations that serves to fetch the totals of several budgets. And each budget has one piece ( part_id ) that can have several works: +---------+-------------+----------+-----------------+ | part_id | al...
asked by 03.03.2017 / 18:23
1
answer

SQL counting data from the second INNER JOIN table, but should not it?

I have 2 tables: sponsors dimensions What I need to do is check how many sponsorships have been nominated but only count the users who have the record in the cotas table. The SQL I made is as follows:    SELECT COUNT(*) A...
asked by 06.03.2017 / 01:07
1
answer

Real-time data filtering using Jquery

I am building a comment system and would like that when the user selects the value of a select field, a variable would be sent to a PHP page with the selected value, and it would return the results inside a div. > <form> <div class...
asked by 06.03.2017 / 21:47
1
answer

General error error: 1449 when searching MySQL Bank records

I'm getting the error below when doing SELECT: SELECT * FROM vn_horario_view;    SQLSTATE [HY000]: General error: 1449 The user specified as a definer ('root' @ 'localhost') does not exist How do I resolve this error?     
asked by 22.02.2017 / 20:00