I have in my database a category defined as TERRENO / ÁREAS that when doing the following SQL query does not return any results from the existing 18.
SELECT * FROM property WHERE 1 = 1 AND CATEGORY IN ('LAND / AREAS')
This query alre...
I'm new to creating PROCEDURE.
I'm trying to create this PROCEDURE plus this error.
DELIMITER //
DROP PROCEDURE IF EXISTS 'P_lgs';
CREATE PROCEDURE 'P_lgs' ( idcod INT, dt VARCHAR(20), ip VARCHAR(20), msg VARCHAR(250), mail VARCHAR(250) )
BE...
I would like to know if it is possible to execute a Trigger when a SELECT is performed in a certain table, for example:
CREATE TABLE IF NOT EXISTS "Conversa" (
"idConversa" SERIAL NOT NULL,
"idEmissorConversa" INT NOT NULL,
"idReceptorCo...
Consider the situation where hundreds of .jpg files are already available in the wp-content/uploads/2014/09 directory by default and need them to appear in the Media Library ( link ) of the WordPress site.
Is there any SQL scrip...
I have a program that has 5 níveis de autorização , Administrador , Gerente , Operador , Usuário , and Convidado .
But for each level it gives a different access to the system.
verification sketch:
&l...
I have a simple command
SELECT MATRICULA FROM ALUNOS WHERE ID_ALUNO IN (1,2,3,4,5,6)
I would like to know how to get a result like this in SQL:
ID | STUDENT
1 | LUIZ
2 | MARIA
3 |
4 | JOHN
5 | CARLOS
6 |
That is, bri...
I sometimes need to query SQL Server 2000 and paginate the results however there is only the TOP clause that limits the number of records returned without an offset. Other banks like MySQL or PostgreSQL have this and query would look like...
I am trying to do an update by taking the value of another table, but the data in the second table is not sent.
By passing the ID of the card:
<a href=index.php?pag=shopcomprar&id={$row['ID']} '>[COMPRAR]</a>
And trying...
I have these two tables in the database (SQL Server)
Banking Table
ID CODIGO NOME
1 246 Banco ABC Brasil S.A.
2 075 Banco ABN AMRO S.A.
3 025 Banco Alfa S.A....