How to divide the empire cms schedule into tables

In the use of Imperial CMs, as time goes by, the website will become larger and larger, and at this time, sub-tables will inevitably appear.

Establishment of Empire CMS sub-table

First enter the background of Empire, click System-Data Table and System Model-Manage Data table, and then you can see a familiar screen

Here, find the database you need to modify or migrate, and then click Manage Tables at the back

After opening the sub-table, click Add. Although it is said that you can set the sub-table name yourself, for the convenience of subsequent operations, it is recommended that you just use the default digital sub-table. Don't change it casually.

Then you can come to the sql background to operate. You need to use the sql command line here. If you don’t know much about it, you can also use PhpMyadmin to operate. In order for everyone to understand, dolphins are also here. Use pma to operate.

Empire CMS sub-table data transfer

After entering phpmyadmin, click on the database that needs to be operated, and then do not click on the database on the right. Click SQL directly to enter the command operation line, and capitalize

Here you can enter your favorite command

INSERT INTO phome_ecms_28_data_2
SELECT * FROM phome_ecms_28_data_1 T2
WHERE T2.ID>= 100001 AND T2.ID<= 200000;
update phome_ecms_28 set stb=REPLACE(stb,1,2)
WHERE ID>= 100001 AND ID<= 200000;

Explanation The meaning of the following code:

First sentence: Insert rows in the second sub-table of the phome_ecms_28 data table

Second sentence: Copy the first sub-table data of the phome_ecms_28 data table to the data table Second sub-table

The third sentence: Limit the ID range of the data information to be copied to 100001 to 200000

The fourth sentence: Change the sub-table ID in the data table phome_ecms_28 for query

Fifth sentence: Limit the ID range of the phome_ecms_28 table to be modified to 100001 to 200000

Recommended: Empire cms website building tutorial

The above is the detailed content of How to divide the empire cms schedule into tables. For more information, please follow other related articles on the PHP Chinese website!