When I first register the item in the database it picks up the date it was created and saved in the database, the problem happens when I edit the item in the program and then saved in the database it saves a new date.
Item:
String nome;
int...
I'm trying to generate a ranking of faults for HR.
Fault logging is done in a separate table in the Employee registry.
I need to bring the list of active employees and the amount of absences he has had in the company, but I want to order from...
Good afternoon. I have a web application developed in C # that uses connection to Mysql bank. I added the reference, the codebehind recognizes the reference to Mysql without problems. Except when running the application, it gives the error: Erro...
I'm trying to name constraints in MySQL but without success, I'm doing it as follows:
create table if not exists pessoas
(
id int auto_increment,
nome varchar(30) not null,
data_nascimento date,
constraint pk_pess...
I'm using this datepicker in my project, it's already configured as you can see below the DateFormat in the format d / m / Y, but I would like it when I save it in the database it would convert to YMD format, / p>
<link rel="stylesheet"...
Good morning,
On MySql data synchronization where you have both the master server and the slave server, I would like to know if it is possible for me to have multiple master for a single slave, where the master would synchronize with the slave b...
UPDATE 'tabela' SET 'Relacionar_A' =
(SELECT 'Relacionar_A' FROM 'tabela' WHERE 'Relacionar_A'='' ORDER BY RAND() LIMIT 2)
I can only do% single , only 1 record from update .
What I would like - and that I did not get a look for (pro...
Then, when I do the request of the text in the database through this statement in php <?=converte($linha['DESCRICAO_PARA_WEB'], 0)?> the text is presented all in block without the line breaks. This function converts is the change...
Good evening, I have a store system. A database in MySQL for all, I am re-structuring, but I have a dilemma to solve.
Customer registration! Because I have only one bank, I have only one registration for each client. But the customer can buy...