How to INSERT row in another database/schema in MySQL

Let's say I have the following database/schema setup with the following tables:

SCHEMA_1 (default):
        TABLE_1

    SCHEMA_2:
        TABLE_2

How do I insert rows in another schema's table? The following does not seem to work:

INSERT INTO TABLE_2 (...) VALUES(...)

How is it possible to insert rows in another another schema?

It should be fully qualified table name means DatabaseName.TableName
In your case it will be

Insert into schema1.table1 (select * from schema2.table2);

This will insert all rows from schema2.table2 to schema1.table1

StackExchange Database Administrators Q#16302, answer score: 2