⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 invoice.sql

📁 十分好的一个医院管理系统
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223155600',
	2,
	'014095',
	'5-1-2002 0:0:0.000',
	'12-23-2002 15:55:0.000',
	1,
	1,
	247.62,
	0,
	0,
	27,
	12381.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	2.83,
	3.50,
	0,
	742.86,
	247.62,
	350.38,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223155600',
	3,
	'014095',
	'6-1-2002 0:0:0.000',
	'12-23-2002 15:55:0.000',
	1,
	1,
	247.62,
	0,
	0,
	27,
	12381.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	2.83,
	3.50,
	0,
	742.86,
	247.62,
	350.38,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223155600',
	4,
	'014095',
	'7-1-2002 0:0:0.000',
	'12-23-2002 15:55:0.000',
	1,
	1,
	247.62,
	0,
	0,
	27,
	12381.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	2.83,
	3.50,
	0,
	742.86,
	247.62,
	350.38,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223155600',
	5,
	'014095',
	'8-1-2002 0:0:0.000',
	'12-23-2002 15:55:0.000',
	1,
	1,
	247.62,
	0,
	0,
	27,
	12381.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	2.83,
	3.50,
	0,
	742.86,
	247.62,
	350.38,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223155600',
	6,
	'014095',
	'9-1-2002 0:0:0.000',
	'12-23-2002 15:55:0.000',
	1,
	1,
	247.62,
	0,
	0,
	27,
	12381.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	2.83,
	3.50,
	0,
	742.86,
	247.62,
	350.38,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223155600',
	7,
	'014095',
	'10-1-2002 0:0:0.000',
	'12-23-2002 15:55:0.000',
	1,
	1,
	247.62,
	0,
	0,
	27,
	12381.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	2.83,
	3.50,
	0,
	742.86,
	247.62,
	350.38,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223155600',
	8,
	'014095',
	'11-1-2002 0:0:0.000',
	'12-23-2002 15:55:0.000',
	1,
	1,
	247.62,
	0,
	0,
	27,
	12381.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	2.83,
	3.50,
	0,
	742.86,
	247.62,
	350.38,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223155600',
	9,
	'014095',
	'12-1-2002 0:0:0.000',
	'12-23-2002 15:55:0.000',
	1,
	1,
	247.62,
	150,
	0,
	27,
	12381.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	2.83,
	3.50,
	0,
	742.86,
	247.62,
	350.38,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223161947',
	1,
	'014270',
	'1-1-2002 0:0:0.000',
	'12-23-2002 16:14:0.000',
	1,
	1,
	59.60,
	0,
	0,
	6,
	2980.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.05,
	3.50,
	0,
	178.80,
	59.60,
	90.89,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223161947',
	2,
	'014270',
	'2-1-2002 0:0:0.000',
	'12-23-2002 16:14:0.000',
	1,
	1,
	59.60,
	0,
	0,
	6,
	2980.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.05,
	3.50,
	0,
	178.80,
	59.60,
	90.89,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223161947',
	3,
	'014270',
	'3-1-2002 0:0:0.000',
	'12-23-2002 16:14:0.000',
	1,
	1,
	59.60,
	0,
	0,
	6,
	2980.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.05,
	3.50,
	0,
	178.80,
	59.60,
	90.89,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223161947',
	4,
	'014270',
	'4-1-2002 0:0:0.000',
	'12-23-2002 16:14:0.000',
	1,
	1,
	59.60,
	0,
	0,
	6,
	2980.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.05,
	3.50,
	0,
	178.80,
	59.60,
	90.89,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223161947',
	5,
	'014270',
	'5-1-2002 0:0:0.000',
	'12-23-2002 16:14:0.000',
	1,
	1,
	59.60,
	0,
	0,
	6,
	2980.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.05,
	3.50,
	0,
	178.80,
	59.60,
	90.89,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223161947',
	6,
	'014270',
	'6-1-2002 0:0:0.000',
	'12-23-2002 16:14:0.000',
	1,
	1,
	59.60,
	0,
	0,
	6,
	2980.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.05,
	3.50,
	0,
	178.80,
	59.60,
	90.89,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223161947',
	7,
	'014270',
	'7-1-2002 0:0:0.000',
	'12-23-2002 16:14:0.000',
	1,
	1,
	59.60,
	0,
	0,
	6,
	2980.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.05,
	3.50,
	0,
	178.80,
	59.60,
	90.89,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223161947',
	8,
	'014270',
	'8-1-2002 0:0:0.000',
	'12-23-2002 16:14:0.000',
	1,
	1,
	59.60,
	0,
	0,
	6,
	2980.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.05,
	3.50,
	0,
	178.80,
	59.60,
	90.89,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223161947',
	9,
	'014270',
	'9-1-2002 0:0:0.000',
	'12-23-2002 16:14:0.000',
	1,
	1,
	59.60,
	0,
	0,
	6,
	2980.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.05,
	3.50,
	0,
	178.80,
	59.60,
	90.89,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223161947',
	10,
	'014270',
	'10-1-2002 0:0:0.000',
	'12-23-2002 16:14:0.000',
	1,
	1,
	59.60,
	0,
	0,
	6,
	2980.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.05,
	3.50,
	0,
	178.80,
	59.60,
	90.89,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223161947',
	11,
	'014270',
	'11-1-2002 0:0:0.000',
	'12-23-2002 16:14:0.000',
	1,
	1,
	59.60,
	0,
	0,
	6,
	2980.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.05,
	3.50,
	0,
	178.80,
	59.60,
	90.89,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223161947',
	12,
	'014270',
	'12-1-2002 0:0:0.000',
	'12-23-2002 16:14:0.000',
	1,
	1,
	59.60,
	240,
	0,
	6,
	2980.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.05,
	3.50,
	0,
	178.80,
	59.60,
	90.89,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223163334',
	1,
	'014252',
	'1-1-2002 0:0:0.000',
	'12-23-2002 16:33:0.000',
	1,
	1,
	73.02,
	0,
	0,
	8,
	3651.00,
	1,
	538.00,
	0,
	0,
	6.00,
	2.00,
	2.98,
	3.50,
	0,
	219.06,
	73.02,
	108.80,
	18.83,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223163334',
	2,
	'014252',
	'2-1-2002 0:0:0.000',
	'12-23-2002 16:33:0.000',
	1,
	1,
	73.02,
	0,
	0,
	8,
	3651.00,
	1,
	538.00,
	0,
	0,
	6.00,
	2.00,
	2.98,
	3.50,
	0,
	219.06,
	73.02,
	108.80,
	18.83,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223163334',
	3,
	'014252',
	'3-1-2002 0:0:0.000',
	'12-23-2002 16:33:0.000',
	1,
	1,
	73.02,
	0,
	0,
	8,
	3651.00,
	1,
	538.00,
	0,
	0,
	6.00,
	2.00,
	2.98,
	3.50,
	0,
	219.06,
	73.02,
	108.80,
	18.83,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223163334',
	4,
	'014252',
	'4-1-2002 0:0:0.000',
	'12-23-2002 16:33:0.000',
	1,
	1,
	73.02,
	0,
	0,
	8,
	3651.00,
	1,
	538.00,
	0,
	0,
	6.00,
	2.00,
	2.98,
	3.50,
	0,
	219.06,
	73.02,
	108.80,
	18.83,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223163334',
	5,
	'014252',
	'5-1-2002 0:0:0.000',
	'12-23-2002 16:33:0.000',
	1,
	1,
	73.02,
	0,
	0,
	8,
	3651.00,
	1,
	538.00,
	0,
	0,
	6.00,
	2.00,
	2.98,
	3.50,
	0,
	219.06,
	73.02,
	108.80,
	18.83,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223163334',
	6,
	'014252',
	'6-1-2002 0:0:0.000',
	'12-23-2002 16:33:0.000',
	1,
	1,
	73.02,
	0,
	0,
	8,
	3651.00,
	1,
	538.00,
	0,
	0,
	6.00,
	2.00,
	2.98,
	3.50,
	0,
	219.06,
	73.02,
	108.80,
	18.83,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223163334',
	7,
	'014252',
	'7-1-2002 0:0:0.000',
	'12-23-2002 16:33:0.000',
	1,
	1,
	73.02,
	0,
	0,
	8,
	3651.00,
	1,
	538.00,
	0,
	0,
	6.00,
	2.00,
	2.98,
	3.50,
	0,
	219.06,
	73.02,
	108.80,
	18.83,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223163334',
	8,
	'014252',
	'8-1-2002 0:0:0.000',
	'12-23-2002 16:33:0.000',
	1,
	1,
	73.02,
	0,
	0,
	8,
	3651.00,
	1,
	538.00,
	0,
	0,
	6.00,
	2.00,
	2.98,
	3.50,
	0,
	219.06,
	73.02,
	108.80,
	18.83,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223163334',
	9,
	'014252',
	'9-1-2002 0:0:0.000',
	'12-23-2002 16:33:0.000',
	1,
	1,
	73.02,
	0,
	0,
	8,
	3651.00,
	1,
	538.00,
	0,
	0,
	6.00,
	2.00,
	2.98,
	3.50,
	0,
	219.06,
	73.02,
	108.80,
	18.83,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223163334',
	10,
	'014252',
	'10-1-2002 0:0:0.000',
	'12-23-2002 16:33:0.000',
	1,
	1,
	73.02,
	0,
	0,
	8,
	3651.00,
	1,
	538.00,
	0,
	0,
	6.00,
	2.00,
	2.98,
	3.50,
	0,
	219.06,
	73.02,
	108.80,
	18.83,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223163334',
	11,
	'014252',
	'11-1-2002 0:0:0.000',
	'12-23-2002 16:33:0.000',
	1,
	1,
	73.02,
	0,
	0,
	8,
	3651.00,
	1,
	538.00,
	0,
	0,
	6.00,
	2.00,
	2.98,
	3.50,
	0,
	219.06,
	73.02,
	108.80,
	18.83,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223163334',
	12,
	'014252',
	'12-1-2002 0:0:0.000',
	'12-23-2002 16:33:0.000',
	1,
	1,
	73.02,
	240,
	0,
	8,
	3651.00,
	1,
	538.00,
	0,
	0,
	6.00,
	2.00,
	2.98,
	3.50,
	0,
	219.06,
	73.02,
	108.80,
	18.83,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223163824',
	1,
	'014308',
	'1-1-2002 0:0:0.000',
	'12-23-2002 16:38:0.000',
	1,
	2,
	8822.76,
	0,
	0,
	697,
	441138.00,
	240,
	176451.00,
	0,
	0,
	6.00,
	2.00,
	2.94,
	3.50,
	0,
	26468.28,
	8822.76,
	12969.46,
	6175.79,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223163824',
	2,
	'014308',
	'2-1-2002 0:0:0.000',
	'12-23-2002 16:38:0.000',
	1,
	2,
	8822.76,
	0,
	0,
	697,
	441138.00,
	240,
	176451.00,
	0,
	0,
	6.00,
	2.00,
	2.94,
	3.50,
	0,
	26468.28,
	8822.76,
	12969.46,
	6175.79,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223163824',
	3,
	'014308',
	'3-1-2002 0:0:0.000',
	'12-23-2002 16:38:0.000',
	1,
	2,
	8822.76,
	0,
	0,
	697,
	441138.00,
	240,
	176451.00,
	0,
	0,
	6.00,
	2.00,
	2.94,
	3.50,
	0,
	26468.28,
	8822.76,
	12969.46,
	6175.79,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223163824',
	4,
	'014308',
	'4-1-2002 0:0:0.000',
	'12-23-2002 16:38:0.000',
	1,
	2,
	8822.76,
	0,
	0,
	697,
	441138.00,
	240,
	176451.00,
	0,
	0,
	6.00,
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -