Questions tagged as 'sql'

Tagged questions
1
answer

Using Case in Order By with union

I'm having trouble using Order by with Case in Union, so it works: select tb_a.nr_rua, tb_a.cod_altura, tb_a.cod_posicao, tb_a.cod_lado where ...... union all select tb_b.nr_rua, tb_b.cod_altura, tb_b.cod_posicao, tb_b.cod_lado where ...... or...
asked by 10.05.2017 / 21:20
1
answer

How to return zero, when JOIN does not bring me a value?

I have a problem with this SQL, when I need to list a move but the code has not yet been written. There when you fall into this JOIN AND A.NCODIMVEPI = E.NCODIMVEPI .and JOIN AND D.NCODIEQEPI = E.NCODIEQEPI . I do not have it,...
asked by 18.04.2017 / 14:44
1
answer

Error trying to create a Proc in the database

I'm trying to run a Stored Procedure in the database and it's giving this message:    Can not grant, deny, or revoke permissions to sa, dbo, entity owner,   information_schema, sys, or yourself How do I resolve this? If Proc already ex...
asked by 17.04.2017 / 21:36
1
answer

php / sql - phpmyadmin binary value show on web page

IhaveadatabaseofbookseachbookhasitsISBN,titleetcandevenhasanimage,whichIuploadedinthedatabaseforeachbook.buttheproblemisthattheimagedoesnotappear,echoestheimagebutdoesnotactuallyappear(seethephotos).ThecodeI'musingtocallthedatabaseimageisasfol...
asked by 21.04.2017 / 19:01
0
answers

code does not display any errors but still does not execute DELETE

The code does not display any errors but still does not execute DELETE. I created a tag to delete line by line and I used GET for it and it still is not working. tag <td><a href="delete_rows.php?del=$row[ISBN]">delete</a&...
asked by 20.04.2017 / 02:25
2
answers

php- blank page

[update1 ThisisthefollowingpagethatyoucanseeintheimageswasworkingbeautywithoutanyproblemandnowIhavebeenuploadingitandsimplythePHPcodedoesnotappear.I'vebeenreadingandsometimestheysaytheycanbemistakes.inaPHPcodecheckerIputmycodethereanditdidnotr...
asked by 20.04.2017 / 05:53
0
answers

MySQL - Value limit for mathematical operations

I have a question regarding the following situation: I have two values not stored in a table. Valor 1: 9223372036854775806 (Onde este é o valor máximo de um tipo de dado BIGINT) Valor 2: 99999999999999999999999999999999999999999999999999999...
asked by 19.04.2017 / 21:35
1
answer

How to create a real-time list with PHP and Ajax

I'm creating a recipe site, where the ingredients will be individually registered in a table, referring to the recipe id, example of how the tables are: ptp_receitas id|nome 1 |receita de feijão ptp_receitas_ingredientes id|id_receita|ingredi...
asked by 06.04.2018 / 15:01
1
answer

How to assign the value of an Excel column in an SQL statement

I was able to connect to my MySQL Database via ODBC, and display the information I need via SQL command, but I would like the contents of a particular cell in my worksheet to be in that SQL query, I get this: Showonlythenameoftheclientaccord...
asked by 10.04.2017 / 17:03
0
answers

Laravel Query Builder returning duplicate values?

I have the following problem, I have a select using leftJoin , plus this is returning duplicate records, the database is not duplicated and when I run leftJoin it works. Follow SQL Tabela processo -----------------------...
asked by 09.04.2017 / 17:02