How to create a mysql trigger to update a table in another database?

Question

MySQL

creation of tables test DB billing;

USE billing;
CREATE TABLE `test` (
`id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`content` TEXT NOT NULL 
) ENGINE = innodb;

creating a test table in another database billing_test

USE billing_test;
CREATE TABLE `test` (
`id` INT( 11 ) UNSIGNED NOT NULL PRIMARY KEY,
`content` TEXT NOT NULL 
) ENGINE = innodb;

Trigger updates on insert another table in another table

use billing;
DELIMITER //
CREATE TRIGGER `update_test3` AFTER INSERT ON `test`
FOR EACH ROW 
BEGIN
   INSERT INTO `billing_test.test` set id = NEW.ID, content = NEW.content;
-- как правильно здесь указать таблицу из другой базы??????
END; 
//
DELIMITER ;

at insert

INSERT INTO billing.test(content) VALUE("TEST NEW TRIGEER");

gives this error(
->
Table 'billing.billing_test.test' doesn't exist C:\Users\UserA\Documents\SQL.sql

Answer 1

`billing_test.test` is the name of the table in the current database
`billing_test`.`test` is the test table in the billing_test database

Answer 2

Perhaps your code is just an example, but it has syntactical problems
The INSERT code should look different (in a trigger)
"Might help"