Knex currently implements auto-incrementing columns in Oracle using a legacy approach that relies on sequences and triggers. When a user calls table.increments('id'), Knex generates two SQL statements ...
SET @max_customer_id = (SELECT COALESCE(MAX(CustomerID), 0) FROM customers); UPDATE customers SET CustomerID = (@max_customer_id := @max_customer_id + 1) WHERE CustomerID = 0; -- Now safe to add ...
一部の結果でアクセス不可の可能性があるため、非表示になっています。
アクセス不可の結果を表示する