Questions tagged as 'mysql'

Tagged questions
0
answers

How to display listing of the same data?

I am creating a sales system and would like to list the quantity sold for each product. So I would not repeat the name of the product, but only the quantity sold. ThewayIdidislikethisbutIwouldlikesuggestions.<?phpif($_GET['busca']=="data"...
asked by 11.08.2017 / 21:44
1
answer

Problem returning data with PDO from MySQL

I have a query that returns the permissions of a certain group of users on my system. I use MySQL with PHP. My SQL command is as follows: select p.Codigo, p.Descricao, (case when gp.CodGrupoUsuario is null then 0 else 1 end) as TemPerm...
asked by 12.08.2017 / 23:55
0
answers

What is the best way to store an array in a single field in the database

Generally, implode/explode or serialize/unserialize is used to store multiple information for a particular item in the database. Using PDO, what would be the best and if there is another way to store an array in a single database f...
asked by 24.07.2017 / 22:36
0
answers

Help to optimize an index in mysql

I have a relationship website and for years I've tried to optimize this query. Almost every day the site hangs because of it. User table structure CREATE TABLE 'usuarios' ( 'id' bigint(20) NOT NULL, 'nome' varchar(25) CHARACTER SET utf8...
asked by 26.07.2017 / 07:48
0
answers

Asynchronous nature of nodejs, loop for com querie mysql

Inside an upload route in nodejs I have this: router.post('/uploads',function(req,res){ //Omitido algumas instruções para melhorar o entendimento. InsereMidia = function(midia){ ExisteMidia(midia,function(midias_linhas){...
asked by 29.07.2017 / 20:18
1
answer

Error in insert MSQLI [closed]

I am changing from mysql_ to mysqli, everything works (update and delete) more in the insert does not save .... where is the error? insert file: include("config/con_mysqli.php"); $sigla = $_REQUEST['sigla']; $nome...
asked by 19.07.2017 / 14:22
0
answers

Not returning the value when I use the QT C ++ query

When I use the following query to return the docile of the bank's data, the following message appears: QSqlQuery :: value: not positioned on a valid record I use the same code model and it is working, only the one that does not, it follows...
asked by 19.07.2017 / 15:04
0
answers

Error connecting to MySql database using C # application in Visual Studio [closed]

Hello, I created the registration form and at the time I am going to save the text box items in the database the following error 'Host' DESKTOP_R70LLO is not allowed to connect to this MySql server '. By my diligence to try to solve the error an...
asked by 19.07.2017 / 23:04
0
answers

Problems with dynamic programming of DIV's in php

Good afternoon! I'm working on a project that involves building a website about a very popular game. This same website will have "coinflip" functionality This feature consists of a betting system where: The first player indicates the op...
asked by 12.07.2017 / 18:10
0
answers

Trigger does not work

I do not have much practice in MySQL and I need to create a trigger to update a column of a table when a new record is inserted, but when you insert a new row, nothing happens. I've already changed everything I could and I could not make the tri...
asked by 12.07.2017 / 15:08