Questions tagged as 'mysql'

Tagged questions
1
answer

MYSQL numerical alpha code

I want to code a MySQL DOMAIN in a random code, with 2 letters, 1 number, 1 letter, 2 numbers    AB-1A-21-DA-2B-35-CI-3U-23 How to proceed?     
asked by 29.11.2018 / 15:02
1
answer

Get the last record by date from a posting history in mysql

I need to get the last donation situation in a given period. I need to group by donation and situation. Add up by situation and order donations by situation, taking only the last. Tabela LoteRetornoDoacao Campos: id,dtBaixa,situacaoDoacao,vrTo...
asked by 30.11.2018 / 01:49
1
answer

JOIN of 3 tables (LEFT JOIN)

I have a question regarding the best way (regarding performance and execution) to do the following select ... Initially I thought about using LEFT JOIN, but I came across some restrictions on its LEFT JOIN feature. Having 3 following tables:...
asked by 06.11.2018 / 00:44
1
answer

Result Grouped by Field and Listing N records

I have a table named area with the structure: Id, Nome, Status I have another table called news with the structure: Id,Título,Descricao,Data,IdArea,Status I would like to return all newsgroups grouped by area code, where the result wou...
asked by 26.09.2018 / 01:57
1
answer

Add access level to this php code

<?PHP include('config.php'); # Validar os dados do usuário function anti_sql_injection($string) { include('config.php'); $string = stripslashes($string); $string = strip_tags($string); $string = mysqli_real...
asked by 25.09.2018 / 18:34
1
answer

code smell - select max (numberProntuario) +1, but how to fix it?

I have a Paciente mysql table, in it I have the column id , nome , numeroProntuario etc. This column numeroProntuario is defined by the increment of +1 resulting from select max(numeroProntuario) (legacy c...
asked by 24.09.2018 / 21:51
1
answer

Problems using INSERT in PHP (mysqli)

I (beginner in the php development area) I'm having trouble inserting data using the code below: <?php $conn = new mysqli("zz", "zz", "zz", "zz"); // Alterei a string de conexão por questão de segurança if ($conn->connect_error) {...
asked by 04.10.2018 / 15:48
1
answer

The requested file could not be loaded: products / list_table.php

I'm trying to display a view data coming from the database, when I tried to run the following message appeared: Um erro encontrado Não foi possível carregar o arquivo solicitado: produtos / lista_tabela.php products = name of m...
asked by 04.10.2018 / 22:13
1
answer

how do I change my root password in windows?

I lost the root password I put when I installed MySQL, but I do not know how to reset / change without knowing the password     
asked by 09.12.2018 / 16:43
1
answer

What is the best Mysql Type to store numeric values

I have a table where I store the number of places in numeric values. I would like to know the best mysql type to store these values, taking into consideration that it can be calculated with another field that will receive the same type from anot...
asked by 03.10.2018 / 23:39