【实例简介】农历公历数据sql,包含闰月数据,天干地支,风水等数据,是从1900年到2100年每一天的数据
【实例截图】
【核心代码】
类似如下结构:
insert into test.lunar_info (id, year, month, day, week, lunarYear, lunarMonth, lunarDay, cnyear, cnmonth, cnday, cyclicalYear, cyclicalMonth, cyclicalDay, animal, bigMonth, maxDayInMonth, jieqi, suit, taboo, lunarYearString, hyear, leap) values (19000201, 1900, 2, 1, 'Thursday', 1900, 1, 2, '壹玖零零', '正', '初二', '己亥', '丁丑', '乙巳', '鼠', 0, 29, '{"4":"立春","19":"雨水"}', '嫁娶,订盟,纳采,会亲友,祭祀,安机械,移徙,入宅,盖屋,安床,起基,定磉,安香,出火,挂匾,拆卸,置产', '开市,出行,安葬,行丧', '庚子', '庚子', 0);
insert into test.lunar_info (id, year, month, day, week, lunarYear, lunarMonth, lunarDay, cnyear, cnmonth, cnday, cyclicalYear, cyclicalMonth, cyclicalDay, animal, bigMonth, maxDayInMonth, jieqi, suit, taboo, lunarYearString, hyear, leap) values (19000202, 1900, 2, 2, 'Friday', 1900, 1, 3, '壹玖零零', '正', '初三', '己亥', '丁丑', '丙午', '鼠', 0, 29, '{"4":"立春","19":"雨水"}', '沐浴,捕捉,畋猎,理发,整手足甲,入殓,除服,成服,破土,安葬,谢土,立碑,修坟,启钻', '纳采,订盟,嫁娶,上梁,开市,斋醮,盖屋,安门', '庚子', '庚子', 0);
insert into test.lunar_info (id, year, month, day, week, lunarYear, lunarMonth, lunarDay, cnyear, cnmonth, cnday, cyclicalYear, cyclicalMonth, cyclicalDay, animal, bigMonth, maxDayInMonth, jieqi, suit, taboo, lunarYearString, hyear, leap) values (19000203, 1900, 2, 3, 'Saturday', 1900, 1, 4, '壹玖零零', '正', '初四', '己亥', '丁丑', '丁未', '鼠', 0, 29, '{"4":"立春","19":"雨水"}', '祭祀,破屋,坏垣,馀事勿取', '斋醮,嫁娶,开市', '庚子', '庚子', 0);
insert into test.lunar_info (id, year, month, day, week, lunarYear, lunarMonth, lunarDay, cnyear, cnmonth, cnday, cyclicalYear, cyclicalMonth, cyclicalDay, animal, bigMonth, maxDayInMonth, jieqi, suit, taboo, lunarYearString, hyear, leap) values (19000204, 1900, 2, 4, 'Sunday', 1900, 1, 5, '壹玖零零', '正', '初五', '庚子', '戊寅', '戊申', '鼠', 0, 29, '{"4":"立春","19":"雨水"}', '祭祀,解除,治病,破屋,坏垣,扫舍', '馀事勿取', '庚子', '庚子', 0);
insert into test.lunar_info (id, year, month, day, week, lunarYear, lunarMonth, lunarDay, cnyear, cnmonth, cnday, cyclicalYear, cyclicalMonth, cyclicalDay, animal, bigMonth, maxDayInMonth, jieqi, suit, taboo, lunarYearString, hyear, leap) values (19000205, 1900, 2, 5, 'Monday', 1900, 1, 6, '壹玖零零', '正', '初六', '庚子', '戊寅', '己酉', '鼠', 0, 29, '{"4":"立春","19":"雨水"}', '祭祀,祈福,求嗣,开光,出火,出行,拆卸,修造,动土,入宅,移徙,上梁,挂匾,开池,入殓,安葬,破土,启钻', '嫁娶,作灶,安床', '庚子', '庚子', 0);
insert into test.lunar_info (id, year, month, day, week, lunarYear, lunarMonth, lunarDay, cnyear, cnmonth, cnday, cyclicalYear, cyclicalMonth, cyclicalDay, animal, bigMonth, maxDayInMonth, jieqi, suit, taboo, lunarYearString, hyear, leap) values (19000206, 1900, 2, 6, 'Tuesday', 1900, 1, 7, '壹玖零零', '正', '初七', '庚子', '戊寅', '庚戌', '鼠', 0, 29, '{"4":"立春","19":"雨水"}', '结网,入殓,除服,成服,移柩,安葬,破土', '诸事不宜', '庚子', '庚子', 0);
insert into test.lunar_info (id, year, month, day, week, lunarYear, lunarMonth, lunarDay, cnyear, cnmonth, cnday, cyclicalYear, cyclicalMonth, cyclicalDay, animal, bigMonth, maxDayInMonth, jieqi, suit, taboo, lunarYearString, hyear, leap) values (19000207, 1900, 2, 7, 'Wednesday', 1900, 1, 8, '壹玖零零', '正', '初八', '庚子', '戊寅', '辛亥', '鼠', 0, 29, '{"4":"立春","19":"雨水"}', '移徙,祭祀,开光,祈福,出行,解除,进人口,雇庸,安床,动土,起基,上梁,安门,解除,', '嫁娶,安葬,破土,作梁,纳畜,牧养,行丧,作灶', '庚子', '庚子', 0);