Questions tagged as 'select'

Tagged questions
4
answers

Select with columns reporting incorrect data

Hello I have one more problem regarding a search in the database. I want to make a SELECT that searches for information such as company code, social reason, year and values (summed). At first, the search for information without the company na...
asked by 08.06.2018 / 15:38
0
answers

___ ___ Do erkimt a SELECT on two of the same server with BANKS INTO OUTFILE output on another server ______ qstntxt ___

I need to make a query on two databases and generate a csv file, but I do not have write access to the mysql server, how does the output file of INTO OUTFILE write to another server?

    
___

I need to make a query on two databases and generate a csv file, but I do not have write access to the mysql server, how does the output file of INTO OUTFILE write to another server?     
asked by 08.06.2018 / 00:49
1
answer

Make Mysql query with 3 tables

I have the following query that should bring the sum of views and last view (table sir_ter_relatorios_terrenos ), sum of favorites (table sir_ter_favoritos ) and person name (table sir_users ) SELECT u.id as idinc, u.name as...
asked by 29.05.2018 / 15:24
0
answers

SQL query on 2 databases on different (mysql) servers

Hello. First, I make it clear that I do not know if this is possible. I'm trying to do a SQL query where I need the INNER JOIN data from 02 tables that are on different servers (a Local Server and another Remote Server). I want to do in...
asked by 27.05.2018 / 18:39
0
answers

How to leave the required selection? and also by default the first available option?

I have a system in php that generates selects according to the information of the database, in case I would like to leave these selects obligatory because they do not go unnoticed and also always leave the first option selected as the default....
asked by 25.05.2018 / 20:50
0
answers

Adding Select value, however Adding new Selects with (Java Script)

Personal Wave, Add selection is already working, a new select is opened at the bottom, and you can delete it ... but now I need each of these to disappear with the others ... if you delete, the sum is taken. .. and if you add another select...
asked by 13.05.2018 / 14:15
0
answers

How to validate select multiple?

Context Home I need to validate the multiple check box. You must validate the second checkbox. DoubtHomeWhereandhowdothesevalidations?InphporjavaScript?ValidationLogic Codes:LocationModality:Displaysthemultiplecheckboxontheedita.blade.phpp...
asked by 09.05.2018 / 14:49
1
answer

How to do MYSQL subtraction

How to correctly subtract these two columns in the SQL script? SELECT DISTINCT b.prefixo as idVeiculo, max(datatroca) as datatroca, max(kmtroca) as kmtroca, max(horimetroca) as horimetroca,...
asked by 01.05.2018 / 23:45
1
answer

select calling or a text field or another select

Guilherme Costamilam I thank you for the answers. I do not know where I'm wrong in the code. I'm just passing by to see if you can help me. <!DOCTYPE html> <html lang="pt-br"> <head> <meta charset=utf-8"/> &...
asked by 01.05.2018 / 06:07
1
answer

Undefined variable: id

Contextualization Home It is necessary for the user to register new locations in the project through the multiple selection box. As will be several locales I do not know how ajax and php process this data. Home The following image shows the mo...
asked by 26.04.2018 / 20:16