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

📄 invoice.sql

📁 十分好的一个医院管理系统
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
	1001.21,
	1451.76,
	445.07,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021219160308',
	3,
	'011239',
	'9-1-2002 0:0:0.000',
	'12-19-2002 16:3:0.000',
	1,
	2,
	4004.85,
	60,
	0,
	76,
	50060.70,
	15,
	12716.30,
	0,
	0,
	6.00,
	2.00,
	2.90,
	3.50,
	3003.64,
	0,
	1001.21,
	1451.76,
	445.07,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021219161634',
	1,
	'011288',
	'1-1-2002 0:0:0.000',
	'12-19-2002 16:13:0.000',
	1,
	2,
	958.28,
	0,
	0,
	71,
	47913.79,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	0,
	2874.83,
	958.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219161634',
	2,
	'011288',
	'2-1-2002 0:0:0.000',
	'12-19-2002 16:13:0.000',
	1,
	2,
	958.28,
	0,
	0,
	71,
	47913.79,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	0,
	2874.83,
	958.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219161634',
	3,
	'011288',
	'3-1-2002 0:0:0.000',
	'12-19-2002 16:13:0.000',
	1,
	2,
	958.28,
	0,
	0,
	71,
	47913.79,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	0,
	2874.83,
	958.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219161743',
	1,
	'011288',
	'4-1-2002 0:0:0.000',
	'12-19-2002 16:17:0.000',
	1,
	2,
	958.28,
	0,
	0,
	71,
	47913.79,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	0,
	2874.83,
	958.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219161743',
	2,
	'011288',
	'5-1-2002 0:0:0.000',
	'12-19-2002 16:17:0.000',
	1,
	2,
	958.28,
	0,
	0,
	71,
	47913.79,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	0,
	2874.83,
	958.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219161743',
	3,
	'011288',
	'6-1-2002 0:0:0.000',
	'12-19-2002 16:17:0.000',
	1,
	2,
	958.28,
	0,
	0,
	71,
	47913.79,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	0,
	2874.83,
	958.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219161812',
	1,
	'011288',
	'7-1-2002 0:0:0.000',
	'12-19-2002 16:18:0.000',
	1,
	2,
	958.28,
	0,
	0,
	71,
	47913.79,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	0,
	2874.83,
	958.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219161812',
	2,
	'011288',
	'8-1-2002 0:0:0.000',
	'12-19-2002 16:18:0.000',
	1,
	2,
	958.28,
	0,
	0,
	71,
	47913.79,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	0,
	2874.83,
	958.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219161812',
	3,
	'011288',
	'9-1-2002 0:0:0.000',
	'12-19-2002 16:18:0.000',
	1,
	2,
	958.28,
	0,
	0,
	71,
	47913.79,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	0,
	2874.83,
	958.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219163502',
	1,
	'011064',
	'1-1-2002 0:0:0.000',
	'12-19-2002 16:35:0.000',
	1,
	1,
	945.44,
	0,
	0,
	21,
	11818.00,
	2,
	1693.68,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	709.08,
	0,
	236.36,
	0,
	59.30,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219163502',
	2,
	'011064',
	'2-1-2002 0:0:0.000',
	'12-19-2002 16:35:0.000',
	1,
	1,
	945.44,
	0,
	0,
	21,
	11818.00,
	2,
	1693.68,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	709.08,
	0,
	236.36,
	0,
	59.30,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219163502',
	3,
	'011064',
	'3-1-2002 0:0:0.000',
	'12-19-2002 16:35:0.000',
	1,
	1,
	945.44,
	0,
	0,
	21,
	11818.00,
	2,
	1693.68,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	709.08,
	0,
	236.36,
	0,
	59.30,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021220085426',
	1,
	'014331',
	'1-1-2002 0:0:0.000',
	'12-20-2002 8:54:0.000',
	1,
	1,
	73.45,
	0,
	0,
	7,
	3672.70,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.03,
	3.50,
	0,
	220.36,
	73.45,
	111.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021220085426',
	2,
	'014331',
	'2-1-2002 0:0:0.000',
	'12-20-2002 8:54:0.000',
	1,
	1,
	73.45,
	0,
	0,
	7,
	3672.70,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.03,
	3.50,
	0,
	220.36,
	73.45,
	111.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021220085426',
	3,
	'014331',
	'3-1-2002 0:0:0.000',
	'12-20-2002 8:54:0.000',
	1,
	1,
	73.45,
	0,
	0,
	7,
	3672.70,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.03,
	3.50,
	0,
	220.36,
	73.45,
	111.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021220085426',
	4,
	'014331',
	'4-1-2002 0:0:0.000',
	'12-20-2002 8:54:0.000',
	1,
	1,
	73.45,
	0,
	0,
	7,
	3672.70,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.03,
	3.50,
	0,
	220.36,
	73.45,
	111.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021220085426',
	5,
	'014331',
	'5-1-2002 0:0:0.000',
	'12-20-2002 8:54:0.000',
	1,
	1,
	73.45,
	0,
	0,
	7,
	3672.70,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.03,
	3.50,
	0,
	220.36,
	73.45,
	111.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021220085426',
	6,
	'014331',
	'6-1-2002 0:0:0.000',
	'12-20-2002 8:54:0.000',
	1,
	1,
	73.45,
	0,
	0,
	7,
	3672.70,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.03,
	3.50,
	0,
	220.36,
	73.45,
	111.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021220085426',
	7,
	'014331',
	'7-1-2002 0:0:0.000',
	'12-20-2002 8:54:0.000',
	1,
	1,
	73.45,
	0,
	0,
	7,
	3672.70,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.03,
	3.50,
	0,
	220.36,
	73.45,
	111.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021220085426',
	8,
	'014331',
	'8-1-2002 0:0:0.000',
	'12-20-2002 8:54:0.000',
	1,
	1,
	73.45,
	0,
	0,
	7,
	3672.70,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.03,
	3.50,
	0,
	220.36,
	73.45,
	111.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021220085426',
	9,
	'014331',
	'9-1-2002 0:0:0.000',
	'12-20-2002 8:54:0.000',
	1,
	1,
	73.45,
	0,
	0,
	7,
	3672.70,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.03,
	3.50,
	0,
	220.36,
	73.45,
	111.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021220085426',
	10,
	'014331',
	'10-1-2002 0:0:0.000',
	'12-20-2002 8:54:0.000',
	1,
	1,
	73.45,
	0,
	0,
	7,
	3672.70,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.03,
	3.50,
	0,
	220.36,
	73.45,
	111.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021220085426',
	11,
	'014331',
	'11-1-2002 0:0:0.000',
	'12-20-2002 8:54:0.000',
	1,
	1,
	73.45,
	0,
	0,
	7,
	3672.70,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.03,
	3.50,
	0,
	220.36,
	73.45,
	111.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021220085426',
	12,
	'014331',
	'12-1-2002 0:0:0.000',
	'12-20-2002 8:54:0.000',
	1,
	1,
	73.45,
	240,
	0,
	7,
	3672.70,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	3.03,
	3.50,
	0,
	220.36,
	73.45,
	111.28,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021220112248',
	1,
	'011298',
	'1-1-2002 0:0:0.000',
	'12-20-2002 11:23:0.000',
	1,
	2,
	1746.20,
	0,
	0,
	159,
	87310.00,
	43,
	28463.00,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	0,
	5238.60,
	1746.20,
	2549.45,
	996.21,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021220112248',
	2,
	'011298',
	'2-1-2002 0:0:0.000',
	'12-20-2002 11:23:0.000',
	1,
	2,
	1746.20,
	0,
	0,
	159,
	87310.00,
	43,
	28463.00,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	0,
	5238.60,
	1746.20,
	2549.45,
	996.21,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021220112248',
	3,
	'011298',
	'3-1-2002 0:0:0.000',
	'12-20-2002 11:23:0.000',
	1,
	2,
	1746.20,
	240,
	0,
	159,
	87310.00,
	43,
	28463.00,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	0,
	5238.60,
	1746.20,
	2549.45,
	996.21,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021220112325',
	1,
	'011298',
	'4-1-2002 0:0:0.000',
	'12-20-2002 11:23:0.000',
	1,
	2,
	1746.20,
	0,
	0,
	159,
	87310.00,
	43,
	28463.00,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	0,
	5238.60,
	1746.20,
	2549.45,
	996.21,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021220112325',
	2,
	'011298',
	'5-1-2002 0:0:0.000',
	'12-20-2002 11:23:0.000',
	1,
	2,
	1746.20,
	0,
	0,
	159,
	87310.00,
	43,
	28463.00,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	0,
	5238.60,
	1746.20,
	2549.45,
	996.21,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021220112325',
	3,
	'011298',
	'6-1-2002 0:0:0.000',
	'12-20-2002 11:23:0.000',
	1,
	2,
	1746.20,
	150,
	0,
	159,
	87310.00,
	43,
	28463.00,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	0,
	5238.60,
	1746.20,
	2549.45,
	996.21,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021220112410',
	1,
	'011298',
	'7-1-2002 0:0:0.000',
	'12-20-2002 11:24:0.000',
	1,
	2,
	1746.20,
	0,
	0,
	159,
	87310.00,
	43,
	28463.00,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	0,
	5238.60,
	1746.20,
	2549.45,
	996.21,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021220112410',
	2,
	'011298',
	'8-1-2002 0:0:0.000',
	'12-20-2002 11:24:0.000',
	1,
	2,
	1746.20,
	0,
	0,
	159,
	87310.00,
	43,
	28463.00,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	0,
	5238.60,
	1746.20,
	2549.45,
	996.21,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021220112410',
	3,
	'011298',
	'9-1-2002 0:0:0.000',
	'12-20-2002 11:24:0.000',
	1,
	2,
	1746.20,
	60,
	0,
	159,
	87310.00,
	43,
	28463.00,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	0,
	5238.60,
	1746.20,
	2549.45,
	996.21,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021220112431',
	1,
	'011298',
	'10-1-2002 0:0:0.000',
	'12-20-2002 11:24:0.000',
	1,
	2,
	1746.20,
	0,
	0,
	159,
	87310.00,
	43,
	28463.00,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	0,
	5238.60,
	1746.20,
	2549.45,
	996.21,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021220112431',
	2,
	'011298',
	'11-1-2002 0:0:0.000',
	'12-20-2002 11:24:0.000',
	1,
	2,
	1746.20,
12345

⌨️ 快捷键说明

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