I am reading XML files of about 50M of information (about a hundred thousand records, may be more), and I have two classes read XML read from a DOM and another SAX.
I'm having a problem in terms of runtimes, take me longer than 10 minutes, ma...
I want to reference a foreign key from a different bank, I have seen in some forums that it is only necessary to 'nome_database'.'nome_tabela' , but it is not working.
My code is as follows:
ALTER TABLE 'relatorio_gestao'.'usuario_setore...
I've already done this and it works fine in C ++. My problem is to do within a select to appear in the table. If anyone wants to see the algorithm in C ++ to help mount it in MySql I can.
My table is this:
The fields after the stat...
What would be the converted SQL query for LINQ:
"SELECT SUM(valor_negocio) valor_negocio, " +
" MONTHNAME(STR_TO_DATE(MONTH(data_inicio), '%m')) mes," +
" STATUS" +
" FROM negocio" +
" WHERE data_inicio BETWEE...
I'm learning how to use Laravel and got caught in an encoding problem. I am trying to use tinker to insert data into my tables, and there I am getting the following error when I try to include a new post:
Illuminate\Database\QueryException w...
Here is the code:
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=...
I have a table named tb_log , in it I have some data id , usuario_id , produto_id , ..., data .
I need to group records by date as follows: All records that have a time difference of up to 10 minutes.
That is,...
I have the SIMULATE and QUESTION tables, where a simulation can have several questions, but one question can only be for a simulated (1-n relationship).
SIMULATED TABLE:
simuladoId
simuladoNome
QUESTION TABLE
questaoId
questaoPergu...
Good evening,
Has anyone used this package or do you know of a similar one that works?
Link: link
Purpose: to launch an event when there is a change in the database.
Before I gave an error saying that it was not allowed to monitor my...
Good morning, I need a way to get all the rest of a string after a given character, for example, I have the following database
Ineedtoalwayssearchfortheremainderofthestringafterthelast"" " ie for the first line I needed to get all " System acce...