Questions tagged as 'mysql'

Tagged questions
0
answers

Retrieve PDF from the Database and display it on the screen

I have a WEB application, using JSF and Primefaces and MYSQL. It has a product registration screen and in it I need to select a PDF, I was able to attach this PDF and an "insert" in the Bank as "BLOB", but at the time of listing, I can not. I...
asked by 05.09.2018 / 19:21
0
answers

SELECT MySql Filter Status

I need a select in which to search for tipo status and responsave l, only that it is catching by several Status, while only needing a count status A count(if(r.reponsavel mae,if(t.tipo=1 ir t.tipo =2)if(t.status = '...
asked by 02.09.2018 / 04:56
0
answers

How to use PDO and PHP to Display in Search Data Table

I have a question. I do not understand why my code is not correct. Please, if you can review it, I would be very happy. <?php require_once "db_connect.php"; //conectar banco $conectar = new PDO("mysql:host=$host;bancodedados=$b...
asked by 10.09.2018 / 21:38
0
answers

Select on one server, insert on another

I use the following query to select data from one database and insert it into another: insert into banco_novo.cliente (codcliente, nome, cpf, rg, sexo, data_nascimento, endereco, bairro, cidade, estado, cep) select codcliente, nome, cpf, rg, I...
asked by 29.08.2018 / 14:16
1
answer

How to do a session

I have a system that has a login page, but it only sees if there is that email and password that the user typed in the database and releases it to the main page. Now I needed to create a profile page for this user so the system needs to know...
asked by 13.04.2018 / 13:58
0
answers

Search first empty space in the database

I have a small application in C #, which creates the auto-supplier code. I would like to know if anyone knows any way the system can look for an empty code, eg:    1 - Manoel       2 - Narcissus       4 - Mustela The next code he...
asked by 03.09.2018 / 18:04
0
answers

MySql hangs when trying to query table with many records (PHP)

I'm trying to make a filter where the query is done in a table where the id of the last record is in the number 468.466 . In the filter, I need to compare with a View, which has its last record id 5,303,345 . The query is as follows: S...
asked by 27.08.2018 / 14:13
1
answer

Mysql help PhpMyAdmin How to insert a table into a bank?

How do I insert a table into a table? I am a beginner mysql user and a beginner in the programming world. I made the following code: INSERT INTO banco1( CREATE TABLE Cliente ( id INT NOT NULL AUTO_INCREMENT nome varchar(60)NOT NULL...
asked by 29.08.2018 / 19:45
0
answers

MySQL query does not return data even if there are records

I am trying to query my BD but strangely it does not return anything, even if there are records with the given parameters, yes, the script still uses mysql_ and I am changing, but I would like to understand why the records do not d...
asked by 29.08.2018 / 20:59
0
answers

Comparing two tables in MYSQL and limiting the result based on the current date

I am comparing the data of these two tables pontos and pontos_view in practice, in the pontos table there is a list of tasks that when executed by the user, saved in pontos_view thus causing the user to not execute th...
asked by 08.09.2018 / 21:03