Good evening, is there any way to generate random names with stored procedures in MySQL?
I have the following table:
ALUNO (id: int [PK], name (varchar (100)), age: int, Cr (float))
I need this table with 10mil entries popular.
To gene...
I am using php with pdo to query a database in postgress .
Is there any way that when I do query , show the result without having to insert the table name, since the select is unique?
select distinct a as origem
from b uni...
I need to recompile all Views, procedures and triggers in Firebird, not by IBExpert, but by Delphi XE2, I will pass a SQL, I would like to know how to perform such a procedure.
I have a procedure that I would like to execute at every X time. I did the scheduling on the sql agent all right. My question is the following, I need to replicate this procedure in all the bases to be able to use with the command:
EXEC sp_MSfo...
Given this query:
SELECT
PontoSecullum4.DBO.funcionarios.N_FOLHA,
PontoSecullum4.DBO.funcionarios.NOME,
PontoSecullum4.DBO.funcionarios.EMPRESA_ID,
1 [ORIGEM]
FROM
PontoSecullum4.DBO.funcionarios
WHERE 1=1
AND NOT EXISTS(
SELECT Cod...
I'm doing a project and I'm having customization issues in my datagrid, as the information in the two textbox returns in the same datagrid I can not customize the header of the two, but rather just one, does anyone know how to sort it wit...
I'm doing a program and would like to know how do I save a field that contains only characters, but just send the code to your bank? I am using two tables to save the data and the field I want to save is the foreign key that would be the code. I...
Hello, while I was developing a system to manage the records in the DB in error it is happening that when inserting the values the date records are empty and when trying to update the listing of information it gives an error that says that it can...
I'm getting an error while trying to insert into the database. See below.
<?php
define("CMD_CRIAR_POST", 0);
define("CMD_BUSCAR_POSTS", 1);
define("CMD_EDITAR_POST", 2);
define("CMD_EXCLUIR_POST", 3);
define("CMD_...