【SQL开源代码栏目提醒】:网学会员在SQL开源代码频道为大家收集整理了hsql-insert.sql提供大家参考,希望对大家有所帮助!
DELETE FROM tx;
DELETE FROM customer_account_xref;
DELETE FROM account;
DELETE FROM customer;
DELETE FROM next_id;
INSERT INTO account VALUES
('5005', 'Money Market', 'Hi Balance', 4000.00, 0.00, 3500.00, '2000-02-28 23:03:20');
INSERT INTO account VALUES
('5006', 'Checking', 'Checking', 85.00, 0.00, 66.54, '2000-04-16 03:12:00');
INSERT INTO account VALUES
('5007', 'Credit', 'Visa', 599.18, 5000.00, 166.08, '2000-03-23 10:13:54');
INSERT INTO account VALUES
('5008', 'Savings', 'Super Interest Account', 55601.35, 0.00, 5433.89, '2000-01-15 12:55:33');
INSERT INTO customer VALUES
('200', 'Jones', 'Richard', 'K',
'88 Poplar Ave.', 'Cupertino', 'CA', '95014',
'408-123-4567', 'rhill@j2ee.com');
INSERT INTO customer VALUES
('201', 'Jones', 'Mary', 'R',
'88 Poplar Ave.', 'Cupertino', 'CA', '95014',
'408-123-4567', 'mhill@
j2ee.com');
INSERT INTO customer_account_xref VALUES
('200', '5005');
INSERT INTO customer_account_xref VALUES
('201', '5005');
INSERT INTO customer_account_xref VALUES
('200', '5006');
INSERT INTO customer_account_xref VALUES
('200', '5007');
INSERT INTO customer_account_xref VALUES
('201', '5006');
INSERT INTO customer_account_xref VALUES
('201', '5007');
INSERT INTO customer_account_xref VALUES
('200', '5008');
INSERT INTO customer_account_xref VALUES
('201', '5008');
INSERT INTO tx VALUES
('00000001', '5005', '2001-10-01 12:55:33', '200.00', '4200.00', 'Refund');
UPDATE account SET balance = 4200.00 WHERE account_id = 5005;
INSERT INTO tx VALUES
('00000003', '5008', '2001-10-03 12:55:33', '-1000.00', '54601.35', 'Transfer Out');
UPDATE account SET balance = 54604.35 WHERE account_id = 5008;
INSERT INTO tx VALUES
('00000004', '5006', '2001-10-03 12:55:33', '1000.00', '1085.00', 'Transfer In');
UPDATE account SET balance = 1085.00 WHERE account_id = 5006;
INSERT INTO tx VALUES
('00000005', '5007', '2001-10-05 12:55:33', '33.00', '199.08', 'Clothing');
UPDATE account SET balance = 199.08 WHERE account_id = 5007;
INSERT INTO tx VALUES
('00000006', '5006', '2001-10-06 12:55:33', '2000.00', '3085.00', 'Paycheck Deposit');
UPDATE account SET balance = 3085.00 WHERE account_id = 5006;
INSERT INTO tx VALUES
('00000007', '5005', '2001-10-07 12:55:33', '-200.00', '4000.00', 'ATM Withdrawal');
UPDATE account SET balance = 3085.00 WHERE account_id = 5005;
INSERT INTO tx VALUES
('00000008', '5006', '2001-10-08 12:55:33', '-200.00', '2885.00', 'Car Insurance');
UPDATE account SET balance = 2885.00 WHERE account_id = 5006;
INSERT INTO tx VALUES
('00000009', '5007', '2001-10-09 12:55:33', '186.00', '385.08', 'Car Repair');
UPDATE account SET balance = 385.08 WHERE account_id = 5007;
INSERT INTO tx VALUES
('00000010', '5008', '2001-10-10 12:55:33', '1000.00', '55601.35', 'Deposit');
UPDATE account SET balance = 55601.35 WHERE account_id = 5008;
INSERT INTO tx VALUES
('00000011', '5007', '2001-10-11 12:55:33', '585.00', '970.08', 'Airplane Tickets');
UPDATE account SET balance = 970.08 WHERE account_id = 5007;
INSERT INTO tx VALUES
('00000012', '5006', '2001-10-12 12:55:33', '-675.00', '2210.00', 'Mortgage Payment');
UPDATE account SET balance = 2210.00 WHERE account_id = 5006;
INSERT INTO tx VALUES
('00000013', '5005', '2001-10-13 12:55:33', '-100.00', '3900.00', 'ATM Withdrawal');
UPDATE account SET balance = 3900.00 WHERE account_id = 5005;
INSERT INTO tx VALUES
('00000014', '5006', '2001-10-14 12:55:33', '-385.08', '1824.92', 'Visa Payment');
UPDATE account SET balance = 1824.92 WHERE account_id = 5006;
INSERT INTO tx VALUES
('00000015', '5007', '2001-10-15 12:55:33', '-385.08', '585.00', 'Payment');
UPDATE account SET balance = 585.00 WHERE account_id = 5007;
INSERT INTO tx VALUES
('00000017', '5007', '2001-10-17 12:55:33', '26.95', '611.95', 'Movies');
UPDATE account SET balance = 611.95 WHERE account_id = 5007;
INSERT INTO tx VALUES
('00000018', '5006', '2001-10-18 12:55:33', '-31.00', '1793.92', 'Groceries');
UPDATE account SET balance = 1793.92 WHERE account_id = 5006;
INSERT INTO tx VALUES
('00000019', '5005', '2001-10-19 12:55:33', '-150.00', '3750.00', 'ATM Withdrawal');
UPDATE account SET balance = 3750.00 WHERE account_id = 5005;
INSERT INTO tx VALUES
('00000020', '5006', '2001-10-20 12:55:33', '2000.00', '3173.92', 'Paycheck Deposit');
UPDATE account SET balance = 3173.92 WHERE account_id = 5006;
INSERT INTO tx VALUES
('0000