Questions tagged as 'mysql'

Tagged questions
1
answer

What is most advisable? Do you query through a list or directly in the database?

I have to perform a query where I need to do 4 INNER JOIN and still use WHERE in several fields. What is most advisable? Conduct the query in this way? using (DbContexto db = new DbContexto()) { var query = (from t1 i...
asked by 19.11.2014 / 17:51
1
answer

Allow a user to view stored procedures created by other users

I have a MySQL database populated with some stored procedures . The problem is that two different users have created several procedures, so that only the user who created the stored procedure can see its contents. In this context, I would like...
asked by 17.11.2014 / 16:56
1
answer

How to list a query without knowing what will be returned?

In this example I defined some attributes to be shown, but in the game I do not know which ones to show because the user is the one who is going to ask the query. <?php while ($row = mysql_fetch_array($qry_result)){?> <tr>...
asked by 21.11.2014 / 00:56
3
answers

Select records from a table where the record of a related table is a specific value

I have a table of technical calls and a table of calls. Each 'CALL' has several 'CALLS' and it is in the calls that the field defines the status of the call (Open, Closed, In Progress, Suspended, etc ...) Currently, when I need to list only op...
asked by 24.03.2014 / 15:42
1
answer

Is there any alternative way to use foreign keys in MyISAM tables?

I'm making an application and I need to relate two tables logically, I could use foreign keys ... The problem is that the database I'm using only allows MyISAM tables that does not support foreign keys like InnoDB. So, how could you work around...
asked by 26.03.2014 / 14:38
1
answer

Vagrant with PHP + MySQL + Linux + Puphpet + ZF2 too slow

I have a Windows-based environment with ZF2, Doctrine, and MySQL that runs very fast. But now I'm experimenting with Vagrant with the machine configured through Puphpet. I was able to make the system work in this environment, but it is extrem...
asked by 05.01.2015 / 19:58
1
answer

Paging, count to calculate limit and offset by MYSQL

I have a query with 7 relationships in a relatively large table, and the list of records uses as a base the total of records, so it would be a query to calculate the total and another to display the records between limit and offset...
asked by 06.01.2015 / 17:23
1
answer

MySQL query problems [closed]

<form method="POST" class="w-100" action="pesquisa_diaria.php"> <div class="card-body"> <div class="row"> <div class="col-sm-3"> <label>Tipo de Venda...
asked by 13.12.2018 / 00:49
3
answers

GROUP BY last record by month and year how to do?

I'm doing a query in the database, follow my table below id | valor | mes | ano | 1 39.69 3 2017 1 7.69 3 2018 3 9.69 4 2015 3 3.69 2 2016 2 5.89 3 2017 2...
asked by 18.12.2018 / 19:07
1
answer

Failed to populate a gridView

I'm having problems displaying a gridview, it's not displaying the right data, it looks like it's trying to display vertically, I've already changed the Gridline property to horizontal, both and now this Name, same as another gridView I've been...
asked by 15.06.2014 / 03:41