Questions tagged as 'mysql'

Tagged questions
2
answers

How to select single data from a conditional join?

I have 2 database tables: servers +----------+--------------+ | Field | Type | +----------+--------------+ | id | int(11) | | ip | varchar(255) | | votes | int(11) | | port | varchar(255) | | hash...
asked by 13.11.2016 / 20:33
1
answer

MySQL table with lots of data

Example case: I have a system with approximately 5 million records, it is recommended to use a single MySQL table to save, for example tabela_empresas_brasil ? since every time the user makes a query will need to search those 5 million r...
asked by 14.09.2016 / 17:21
1
answer

SELECT problems with postgresql

I am doing a migration from mysql to postgres, but there is a mistake, not much experience with postgres: SELECT SELECT m.* , (SELECT c.id FROM corridas c WHERE c.motoqueiro = m.id AND (c.s...
asked by 09.08.2016 / 17:10
1
answer

Random selections with PHP and MySQL

Is there any way to make random selects with php and mysql. Example: I have the table carreta_furacao: id----nome 1----Fofão 2----Capitão América 3----Popeye 4----Mickey 5----Palhaço 2 - In PHP I make a random select * 3- Ret...
asked by 08.06.2016 / 20:17
1
answer

Generate Dynamic HTML with ASP.NET

Good people, I'm having a project, and I need to generate a dynamic HTML card by pulling from an sql server. The case is as follows, I have a CARD in html, all stylized. Which in the case is the code below. <hr class="separador" />...
asked by 14.06.2016 / 16:34
1
answer

Add value to the database

I use Codeigniter, and the situation is this: The product has a current stock, and I want to input more items from this stock ... how do I add the existing one with the new entries? Here is the code: CONTROLLER: public function entrada(){...
asked by 25.07.2016 / 21:45
2
answers

Arduino + Module SIM900 + PHP + MySQL - Problem POST method

Good afternoon everyone! I'm developing a project that consists of communicating a SIM900 module with an application, and making the interaction of the two will be a WEB server + database. The APP, Database and PHP page items are already w...
asked by 02.08.2016 / 23:38
2
answers

How to make the PaiChild relation between two select elements?

I am making two elements Select an "Area" and another "Problem" and need to relate to each other, in the problem DB table is the FK spr_sar_code referring to the sar_code of the Area table. I am not able to interact so that the select problem de...
asked by 19.09.2016 / 18:55
1
answer

Multidimensional array from mysql query

Good afternoon, I have a system, with the following tables: pagina: id,nome ,icone, idGrupo. paginaGrupo: id,nome,icone, idGrupoUser. I am putting a dynamic menu on top of these tables. I get the ids of the groups that the user is part o...
asked by 19.09.2016 / 17:38
1
answer

Do not Enter Equal Values PHP and MYSQL [closed]

I have a script in PHP and MySQL that looks in the client table for all clients that have not yet been imported to another bank / table and it imports. In the customer table, you have flag imported with values (0 or 1). I make a sel...
asked by 01.11.2016 / 10:46