Questions tagged as 'mysql'

Tagged questions
2
answers

Return last record of each object [closed]

I have the following table: imovel ano | id | item | valor Records: 2000| 1 | 201 | null 2001| 1 | 211 | 10 2002| 1 | 202 | null 2000| 2 | 201 | null 2001| 2 | 221 | 17 2002| 2 | 211 | 14 2000| 3 | 201 | null What I ne...
asked by 03.08.2017 / 15:53
2
answers

Autocomplete with jquery and mysql does not list options when typing

I have the following form: <?php //CHAMA A CONEXÃO COM O BANCO DE DADOS require('../db/conexao.php'); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatib...
asked by 07.04.2017 / 21:23
2
answers

Select record that has a date field using only the year in the where

How can I do a SELECT in the database in which the records have a field that the format is DATE Ex: (2017-05-15) and in the WHERE clause I want for just the year. I also wanted to know if it is better to use the dates in the database in varchar...
asked by 15.05.2017 / 23:04
1
answer

I'm using a mySQL Bank where I store bookmarks for a map

I'm using a mySQL Database where I store bookmarks from a map (in the table I store the latitude and longitude of these bookmarks) my question is, do I make a select by picking up all markers that are in a proximity radius of a point bookmark),...
asked by 30.03.2017 / 15:10
2
answers

Error returning response with search method

I'm having trouble trying to do a search on the bank and returning the response on the screen. This is my main class: public static void main(String[] args) { pessoaDAO ps = new pessoaDAO(); try { Pessoa pessoa = ps.pesquis...
asked by 29.03.2017 / 16:41
2
answers

tool or technology to assist in controlling database data

I have a web application, which constantly receives the database, the application is all linked to the database. If a change is made it can compromise the whole system, I wanted to be able to go back a point when needed. GIT is for file ve...
asked by 16.03.2017 / 19:34
2
answers

query record between two dates in mysql [duplicate]

I am trying to query MySql as follows: SELECT * FROM 'tabela' WHERE 'data' >= '2017-03-01' AND 'data' <='2017-03-05') The issue is that even though I have multiple records from 2017-03-05, the query only returns me records until 201...
asked by 15.03.2017 / 21:36
1
answer

Logic to display data - Slice days

Good evening. Using PHP, I search for data with MySQL. The table has the following structure: ID | dataHoraInicio | dataHoraTermino | 1 | 2017-05-08 11:28:40 | 2017-05-08 17:52:12 | 2 | 2017-05-08 18:34:02 |...
asked by 11.05.2017 / 01:21
1
answer

Catch image in database

I wanted to know how I could retrieve an image from the database, used php7, the image is stored in the database in type BLOB, I searched the internet and they were very old examples and none worked here, could anyone help me?     
asked by 07.03.2017 / 12:48
1
answer

Synchronize Local and Web Database

I have a system running on a web server, and I also want to put it to run on the local server of the company (intranet), for performance issues ... I noticed that I had a problem with the database synchronization between the two servers ... I...
asked by 07.03.2017 / 19:01