Good afternoon guys, can anyone help me please?
I have two tables, Tabela1 and Tabela2 , I would like to insert data from column carro of Tabela2 into column carro of Tabela1 , but in their respective i...
I have a table and each row has 6 inputs that should be saved in the database as a product.
The system has a button in HTML, which adds another line with 6 inputs, that is, by clicking on submit I need to save an indeterminate number o...
PhpMyAdmin message:
Mensagens do MySQL : Documentação
1064 - Você tem um erro de sintaxe no seu SQL próximo a '@NumeroSerie INT(11),
@Velocidade TINYINT(4),
@Direcao SMALLINT(6),
@Latit' na linha 2
Code that is in er...
I have a syntax problem in my sql code inside the php code, I need to know which video has the largest id in the database to save it to a separate folder with the same id number, so that the path gets saved in the bank.
The error that happens is...
CREATE TRIGGER comissao
ON tb_Pedido
FOR INSERT, UPDATE, DELETE
AS
BEGIN
DECLARE
v_codFuncionario INT DEFAULT NULL;
DECLARE v_dataPedido DATETIME(3) DEFAULT NULL;
DECLARE v_valorComissao DECIMAL(15,4) DEFAULT NULL
IF(SELECT COUNT(*) FROM INSERTE...
At this point I'm studying cloud shared file services like OwnCloud and Pydio.
I'm using Debian 9 as a machine. I installed xampp on it. I usually entered the settings in phpmyadmin and I put the password in the root user.
When you get the...
Good afternoon,
My database is saving dates in the following format "2017-04-19", I do not know if I can change the data already registered in it and the way the data will be saved, so I chose to treat the date in my php code , which I have...
When viewing the tables, show me this message:
This table does not contain a unique column.
Grid edit, checkbox, Edit, Copy and Delete are not available.
I can not change mySQL data. You do not have the edit button.
Thank you...
My doubt is that I need to get the ID with the highest value and enter the information in it. The PHP file is working but I need it to identify the ID with the highest VALUE and insert it into it instead of creating another one.
StartReport.p...