FireBird使用记录

来源：互联网发布：牛客网算法视频百度云编辑：程序博客网时间：2024/05/13 09:49

1、批量执行Insert

EXECUTE BLOCK AS BEGIN
insert into T_GZTAX (TAXID, "MIN", "MAX", RATE, MINUSNUM)
values (2, 500, 2000, 10, 25);
insert into T_GZTAX (TAXID, "MIN", "MAX", RATE, MINUSNUM)
values (3, 2000, 5000, 15, 125);
insert into T_GZTAX (TAXID, "MIN", "MAX", RATE, MINUSNUM)
values (4, 5000, 20000, 20, 375);
insert into T_GZTAX (TAXID, "MIN", "MAX", RATE, MINUSNUM)
values (5, 20000, 40000, 25, 1375);
insert into T_GZTAX (TAXID, "MIN", "MAX", RATE, MINUSNUM)
values (6, 40000, 60000, 30, 3375);
insert into T_GZTAX (TAXID, "MIN", "MAX", RATE, MINUSNUM)
values (7, 60000, 80000, 35, 6375);
insert into T_GZTAX (TAXID, "MIN", "MAX", RATE, MINUSNUM)
values (8, 80000, 100000, 40, 10375);
insert into T_GZTAX (TAXID, "MIN", "MAX", RATE, MINUSNUM)
values (9, 100000, 500000, 45, 15375);

end

2、保留关键字要加“” 使用例如上面的：MIN 要使用"MIN"

3、字符串转时间

CAST('05-05-2011 17:00:16' AS timestamp)

4、Generator

create sequence SEQUENCE_T_GZFUNCAUTH

SET GENERATOR SEQUENCE_T_GZBASEINFO TO 1051