Questions tagged as 'mysql'

Tagged questions
1
answer

Is it possible to use DOUBLE data type on 32-bit systems?

The DOUBLE data type is a 64-bit floating point, but can it be used on 32-bit systems without any problems?     
asked by 22.08.2017 / 19:15
3
answers

How is the join and WHERE with multiple tables made?

I have 4 tables they already have foreign key. aluno: id matricula username curso_id // referencia a id_cursos da tabela cursos, coluna id_cursos. cursos: id_cursos nome_cursos modulos: id_modulos nome_modulos cursos_id...
asked by 04.11.2017 / 14:57
1
answer

CONCAT is not working when column is NULL

I need help with the following code: UPDATE propostas SET obs = CONCAT(obs, 'aaa'), cd_status = 0 WHERE tsk_id = 1 If the obs column is null, it does not load the new note. Could anyone help me?     
asked by 22.10.2018 / 20:10
1
answer

Column for MySql row

I have the following table: | Roll No | Student Name | Q1 | Q2 | Q3 | |--------------|--------------|--------|------|------| | 1 | Aluno 1 | 1 | 1 | 1 | | 2 | Aluno 2 |...
asked by 07.10.2018 / 01:12
1
answer

How to create daily event in Mysql 5.6?

I need Mysql to remove all data from a table every midnight.     
asked by 22.11.2014 / 17:26
3
answers

Select the two largest values of a tuple

I have a query that displays the following result: ID | v1 | v2 | v3 | 54384 | 2.4 | 8 | 2.55 | 54385 | 5.6 | 1 | 3.24 | How to do, in a SELECT , the selection of only the two largest values between the "v1", "v2" and "v3" fie...
asked by 10.12.2014 / 18:02
1
answer

Persistent connection to the Mysql database [closed]

Hello, I would like to know if I have an open database connection (persistent connection) is better than I always close after a query?     
asked by 31.07.2014 / 18:39
1
answer

Extract data from a BLOB field in MySQL

I have a select where it has a column where it is returning me in <BLOB>    QUERY SELECT * FROM user WHERE user_id=1    RETURN: id data_cad user_data 12 2017-03-01 21:38:57 <Blob>    In the BLOB...
asked by 30.03.2017 / 23:49
1
answer

PHP and MySql Session

I have two tables, one for login and password, and one for user data such as address, phone, etc. After signing in I would like the data displayed on the screen not to be the login, but the person's name, with a telephone address. The se...
asked by 21.08.2015 / 13:25
2
answers

Organizing Response Array

How to organize array index of 2nd dimension? Search $stmt = getConn()->query("SELECT hash,id,quantidade FROM pergaminhos"); $resp = $stmt->fetchAll(PDO::FETCH_GROUP|PDO::FETCH_COLUMN); response Array ( [1] => Array...
asked by 22.06.2018 / 08:34