【SQL开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了SQL开源代码-hsql-reset-key.sql的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
DELETE FROM next_account_id;
INSERT INTO next_account_id
VALUES (1 +
(SELECT MAX(CAST (account_id AS INTEGER))
FROM account));
DELETE FROM next_customer_id;
INSERT INTO next_customer_id
VALUES (1 +
(SELECT MAX(CAST (customer_id AS INTEGER))
FROM customer));
DELETE FROM next_tx_id;
INSERT INTO next_tx_id
VALUES (1 +
(SELECT MAX(CAST (tx_id AS INTEGER))
FROM tx));