Questions tagged as 'mysql'

Tagged questions
1
answer

ResultSet GROUP_CONCAT is not recognizing the manipulated values

I have a problem, I have no idea how to solve it. I am running GROUP_CONCAT for a pivot table in MySQL and running by PREPARED STATEMENT . So far so good, now when I try to recover result set I can only recover fixed value...
asked by 21.08.2015 / 16:01
0
answers

Remove a certain value from multiple rows in a table?

I'm having trouble creating an algorithm to scan and exclude certain emails from groups of emails. I have a table where are registered company emails that are displayed on the intranet, with these values are created groups of emails that are...
asked by 16.10.2015 / 20:29
1
answer

Several Count in a Mysql sql

I have 2 tables, one called and another client, I need to return how many calls the client had in the current month, last month and last month, I tried using union, it returned me normally, but I can only do a count. p> SELECT COUNT(*) AS...
asked by 25.07.2015 / 04:44
1
answer

Data Verification

I have a screen that is sending to e-mail table via $_POST . After that it goes to a voting screen. I want to make a way that the email that has already been sent can not vote again, but I'm not sure how to do it. This is my page tha...
asked by 27.07.2015 / 16:39
0
answers

Different results for query Mysql 5.1 and 5.7

We developed a project for a client using MySQL 5.1.68 and at the time of publication we identified that the client's hosting was version 5.7.4. Once the project has been published, we begin to see some strange behaviors in the results return...
asked by 01.09.2015 / 12:54
0
answers

Class mPDF + file_get_contents

I have the following code to generate a PDF file and I want to use file_get_contents to include a graph and a table that are generated dynamically on another page but the result is not what I expected. The code with the class mPDF: <?php...
asked by 01.09.2015 / 15:06
0
answers

PHP - Joining data from 2 Tables

Person, I am new to the Forum I would like to ask for the first help. To summarize: I am developing a call system, where it joins data from other systems. I would like to display all data from 2 sql tables in a php tab, every row exists infor...
asked by 31.08.2015 / 20:28
4
answers

Permission error when trying to access database [closed]

   Error: SQLSTATE [28000] [1045] Access denied for user 'root' @ 'localhost'   (using password: YES)     
asked by 06.02.2014 / 21:19
0
answers

Error inserting in Mysql

I created a form with a system of registration with images and strings and it worked perfectly. I tried to add another product without leaving the page and now the form with the class I created does not work anymore, does anyone have any idea...
asked by 31.08.2015 / 20:24
1
answer

MySQL showing ERROR 1064 (42000) when trying to import a text file

I am trying to import data from a text file into a table in MySQL and it says that there is an error in the syntax in the command below: LOAD DATA LOCAL INFILE 'arquivo.txt' FIELD TEMINATED BY ',' LINES TERMINATED BY '\r\n' (r1, r2, r3, r5,...
asked by 09.07.2015 / 04:02