there is an access data table with nearly 200000 pieces of data. I don"t know when to modify it manually. The format of
is as follows:

there are fields in the Content table

1. Chinese name: Xiao Li English name: xiaoli gender: male
2. Chinese name: Xiao Zhang English name: xiaoyun gender: male
3. Chinese name:-- English name: xiaoma gender: male
4. Chinese name:-- English name: xiaolu gender: male

nearly 50% only have English names, while the Chinese name fields are empty. I want to use SQL statement batch operation to copy English name fields to fields with empty Chinese names.

also does not know whether the sql statement has an if statement. This operation must determine whether the "Chinese name" field is empty. If so, copy the contents of the "English field" to the "Chinese name" field.

ask all the gods for help. How to write this sql statement