Questions tagged as 'mysql'

Tagged questions
1
answer

MySQL, number of rows in a table with values from another table

Today I have a question maybe a bit basic but my mysql is a bit rusty. I have 2 tables one with the names of users is another with a list of messages and wanted to know how many messages each user has. table users id | username --...
asked by 28.11.2015 / 16:29
1
answer

Load button + MYSQL database data by replacing "Select * From table limit 18"

I want to configure a button so that whenever I press the LOAD button + the limit 18 always add +18. EXAMPLE: $ sql="SELECT * FROM portfolio ORDER BY id DESC limit 18"; CLICKED BUTTON $ sql="SELECT * FROM portfolio ORDER BY id DESC li...
asked by 30.11.2015 / 20:54
1
answer

Data does not appear in phpMyAdmin

I am having problems sending data passed by the form + php, and appear in the database .... When I go in phpMyadmin only appears the data that I once handbook, it is not being dynamic to display in phpMyadmin, I would like your help ... I have m...
asked by 01.06.2016 / 23:25
1
answer

Store file with more than 1 Mb MySQL

I'm trying to write a file to a mySQL database using delphi. For files with a size of less than 1Mb, this is working fine, however for larger files I'm having problems. The following error occurred: "MySQL server has gone away". The ini...
asked by 02.06.2016 / 14:02
1
answer

Mysql ambiguous error

I'm having an error in my Select SELECT *, SUM(IF(debito_credito_financeiro = 'D', valor_financeiro, 0)) AS debito, SUM(IF(debito_credito_financeiro = 'C', valor_financeiro, 0)) AS credito, (SELECT SUM(IF(debito_credito_financeiro = 'C', valor...
asked by 02.06.2016 / 14:45
1
answer

Error: You have an error in your SQL syntax [closed]

I'm developing software for an MVC (Model-view-controller) design video store and there's a problem with not changing people's data. When I change the data of the person it displays the following message: "Error changing data!". Class VideoPe...
asked by 28.10.2015 / 19:58
1
answer

Variable returns strange characters

I am using the CPU-Z that when scanning your pc you have the option to save the log in txt or html so that it can be viewed manually. Done that I exported to html and executed INSERT INTO 'root'.'mycomputers'(id, token, html) VALUES (NULL, '08d...
asked by 28.10.2015 / 22:59
1
answer

Mysql query with column created by select in other tables

Good morning guys. Assuming a business rule where I have restaurants, and each user can follow several restaurants, I create a table_restaurant , table_user and table_restaurante_usuario_continued . So when a user starts to follow a rest...
asked by 29.10.2015 / 13:04
2
answers

Select within select sorted by second query mysql

I have a problem, I do not know if I'm doing it right, but come on. I have a table that lists some employees (tblTecnicos). I have another table, which has the service registers that these technicians performed (tblServices), in this table...
asked by 04.09.2015 / 17:07
1
answer

Generos Link ($ _ GET)

I'm working on a project to learn about PHP, and at the moment I've taken a link to access the bank and bring everything that has its same value or id ... <?php $generos = explode(',', $post['genero']); foreach ($generos as $categ...
asked by 25.08.2015 / 23:03