Tag: Cross database connection
-
Post Views: 20 1. Table TABLE_A is in the A database, and the table TABLE_B is in the B database. The two tables are linked together via columns table_a.id , table_b.table_a_id . 2. Refer to the advanced JOIN statement:https://learnku.com/docs/laravel/6.x/queries/5171#211e4f. Reference:https://stackoverflow.com/questions/41423603/join-two-mysql-tables-in-different-databases-on-the-same-server-with-laravel-elo. as shown in Figure 1 3. The final code is as follows 4. The final generated SQL is as follows,…
-
Post Views: 25 1. The correlation of the model Theme is as follows 2. The correlation of the model ThemeInstallation is as follows 3. Error when obtaining the associated attribute: sqlstate[42S02]: base table or view not found: 1146 tableObject_wp.wp_theme_installationdoesn’tt exist . as shown in Figure 1 4. The table Theme_Installation does not exist in object_wp.wp_theme_installation, but actually exists in…