达梦数据库默认就是restrict,所以变成无动作是正常的

     CREATE TABLE customers (
         customer_id INT PRIMARY KEY,
         customer_name VARCHAR(100)
     );
     CREATE TABLE orders (
         order_id INT PRIMARY KEY,
         customer_id INT,
         FOREIGN KEY (customer_id) REFERENCES customers(customer_id) 
     );
          INSERT INTO customers (customer_id, customer_name) VALUES (1, 'John');
     INSERT INTO orders (order_id, customer_id) VALUES (1, 1);
       UPDATE customers SET customer_id = 2 WHERE customer_id = 1;