Synchronization of Phpmyadmin tables

Question

I needed help in PHP My Admin on synchronizing fields in different tables and in the same database.
For example:

Database: Data Base Test
Table test1
columns:
- col1
- col2

Table test2
columns:
- col1
- col3

It needed that, when values were inserted in table 1, table 2 would have column 3 null and columns 1 equal.


Note: I use PHP My Admin version 4.7.4

Answer 1

You can use a TRIGGER for this, see below:

Table1:

CREATE TABLE Teste1(
   ID INT AUTO_INCREMENT PRIMARY KEY,
   Nome NVARCHAR(30) NOT NULL
);

Table 2:

CREATE TABLE Teste2(
   Teste1ID INT PRIMARY KEY,
   Algumacoisa NVARCHAR(50) DEFAULT NULL,

   CONSTRAINT FK_Teste1_em_Teste2
   FOREIGN KEY (Teste1ID)
   REFERENCES Teste1.ID
);

Trigger used to insert new record after an INSERT in Table1:

CREATE TRIGGER Gatilho_Teste1
AFTER INSERT
ON Teste1 FOR EACH ROW
INSERT INTO Teste2(Teste1ID) VALUES(NEW.ID);

See Working:

After each record is inserted in Table 1 Trigger is fired and inserts msm id in table 2, already in column 3 you requested null, so only declare the DEFAULT NULL in the construction of the table.