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

📄 checkin.sql

📁 十分好的一个医院管理系统
💻 SQL
📖 第 1 页 / 共 4 页
字号:
🔍
1234 
	'内科',
	'11-13-2002 0:0:0.000',
	'8-31-2002 15:20:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0019',
	'100080201',
	'011078',
	'011078110317',
	'赖义权',
	'男',
	36,
	'内科',
	'8-21-2002 0:0:0.000',
	'9-11-2002 9:27:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0019',
	'100110201',
	'011078',
	'011078110319',
	'刘弘波',
	'男',
	24,
	'内科',
	'9-14-2002 0:0:0.000',
	'9-23-2002 15:52:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0019',
	'100090201',
	'014319',
	'014319120112',
	'罗红伟',
	'女',
	33,
	'内科',
	'9-7-2002 0:0:0.000',
	'9-21-2002 9:23:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0019',
	'100100201',
	'017008',
	'017008210133',
	'丘官友',
	'男',
	70,
	'内科',
	'9-12-2002 0:0:0.000',
	'9-29-2002 13:5:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0019',
	'100120201',
	'014319',
	'014319210235',
	'王乃龙',
	'男',
	74,
	'内科',
	'9-25-2002 0:0:0.000',
	'10-1-2002 10:34:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0019',
	'100150201',
	'014319',
	'014319110161',
	'王秀成',
	'男',
	44,
	'内科',
	'10-6-2002 0:0:0.000',
	'10-26-2002 16:4:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0019',
	'100130201',
	'014180',
	'014180110004',
	'罗龙昌',
	'男',
	58,
	'内科',
	'9-27-2002 0:0:0.000',
	'10-19-2002 16:26:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0019',
	'100140201',
	'017008',
	'017008210145',
	'温顶芳',
	'男',
	71,
	'内科',
	'9-30-2002 0:0:0.000',
	'10-22-2002 16:42:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0019',
	'100160201',
	'014102',
	'014102110003',
	'李寿业',
	'男',
	39,
	'内科',
	'10-13-2002 0:0:0.000',
	'10-23-2002 12:23:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0019',
	'100170201',
	'018009',
	'018009210050',
	'李茂敷',
	'男',
	65,
	'内科',
	'10-25-2002 0:0:0.000',
	'11-10-2002 16:25:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0019',
	'100180201',
	'014319',
	'014319110188',
	'伍达有',
	'男',
	50,
	'内科',
	'11-2-2002 0:0:0.000',
	'11-16-2002 9:4:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'020913000040',
	'017008',
	'017008110045',
	'叶超',
	'男',
	42,
	'',
	'9-13-2002 16:15:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'157090201',
	'012017',
	'012017210528',
	'黄治周',
	'男',
	61,
	'',
	'8-27-2002 0:0:0.000',
	'12-19-2002 8:52:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'445060201',
	'011042',
	'011042210025',
	'甘开畴',
	'男',
	68,
	'',
	'11-18-2002 0:0:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'643680201',
	'014310',
	'014310210328',
	'陈湘汉',
	'男',
	65,
	'',
	'11-28-2002 0:0:0.000',
	'12-20-2002 9:41:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'654800202',
	'011082',
	'011082210112',
	'吕仕才',
	'男',
	71,
	'',
	'12-3-2002 0:0:0.000',
	'12-30-2002 15:32:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'667780201',
	'012017',
	'012017120380',
	'黄子芬',
	'女',
	25,
	'',
	'6-6-2002 0:0:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'669540201',
	'012017',
	'012017110171',
	'王耀文',
	'男',
	29,
	'',
	'10-28-2002 0:0:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'714230202',
	'014319',
	'014319110009',
	'黄祖昌',
	'男',
	59,
	'',
	'10-28-2002 0:0:0.000',
	'12-24-2002 15:32:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'731690202',
	'011290',
	'011290210195',
	'吕辑高',
	'男',
	75,
	'',
	'6-27-2002 0:0:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'738250201',
	'011050',
	'011050120017',
	'吕秋琼',
	'女',
	49,
	'',
	'6-20-2002 0:0:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'740360201',
	'012017',
	'012017220552',
	'张翠萱',
	'女',
	62,
	'',
	'6-28-2002 0:0:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'747150202',
	'011294',
	'011294110001',
	'吕声群',
	'男',
	60,
	'',
	'12-6-2002 0:0:0.000',
	'12-31-2002 11:9:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'747440201',
	'014315',
	'014315110025',
	'罗孙耿',
	'男',
	24,
	'',
	'7-25-2002 0:0:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'753220201',
	'011284',
	'011284210279',
	'钟庆祥',
	'男',
	69,
	'',
	'8-12-2002 0:0:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'760450201',
	'014312',
	'014312210496',
	'徐超汉',
	'男',
	75,
	'',
	'9-9-2002 0:0:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'763090201',
	'014303',
	'014303210426',
	'阮士鹏',
	'男',
	61,
	'',
	'9-9-2002 0:0:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'775480201',
	'014310',
	'014310220413',
	'刘惠琼',
	'女',
	68,
	'',
	'11-12-2002 0:0:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'777060201',
	'018012',
	'018012220142',
	'钟群华',
	'女',
	72,
	'',
	'11-14-2002 0:0:0.000',
	'12-31-2002 10:4:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'777770201',
	'012017',
	'012017120229',
	'吕小欧',
	'女',
	41,
	'',
	'11-24-2002 0:0:0.000',
	'12-30-2002 10:49:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'779300201',
	'011278',
	'011278110008',
	'周纪荣',
	'男',
	59,
	'',
	'11-20-2002 0:0:0.000',
	'12-17-2002 15:44:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'779530201',
	'011290',
	'011290210211',
	'傅云光',
	'男',
	63,
	'内三科',
	'11-23-2002 0:0:0.000',
	'12-21-2002 9:59:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'781080201',
	'014310',
	'014310210429',
	'冯达英',
	'男',
	90,
	'',
	'11-29-2002 0:0:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'781100204',
	'011321',
	'011321220018',
	'陈翠珍',
	'女',
	49,
	'',
	'11-28-2002 0:0:0.000',
	'12-31-2002 15:59:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'781580203',
	'014306',
	'014306210204',
	'谭福源',
	'男',
	61,
	'',
	'12-3-2002 0:0:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'782530201',
	'014349',
	'014349110044',
	'龚育全',
	'男',
	24,
	'',
	'12-6-2002 0:0:0.000',
	'12-17-2002 15:39:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'782700201',
	'012017',
	'012017120388',
	'蓝倩',
	'女',
	23,
	'',
	'12-8-2002 0:0:0.000',
	'12-30-2002 16:0:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'782850201',
	'014319',
	'014319210181',
	'王德光',
	'男',
	67,
	'',
	'12-5-2002 0:0:0.000',
	'12-18-2002 10:3:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'787460201',
	'011037',
	'011037210017',
	'温超兰',
	'男',
	61,
	'',
	'12-9-2002 0:0:0.000',
	'12-30-2002 9:20:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'787730201',
	'014308',
	'014308210716',
	'刘意清',
	'男',
	69,
	'',
	'12-10-2002 0:0:0.000',
	'12-25-2002 16:16:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'787800201',
	'011078',
	'011078110093',
	'郭春松',
	'男',
	54,
	'',
	'12-9-2002 0:0:0.000',
	'12-17-2002 15:8:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'799930201',
	'011284',
	'011284210270',
	'李增沧',
	'男',
	72,
	'',
	'11-25-2002 0:0:0.000',
	'12-29-2002 15:21:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'010102',
	'011291',
	'011291210165',
	'林远光',
	'男',
	68,
	'',
	'4-19-2002 0:0:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'090201',
	'011160',
	'011160110035',
	'甘光全',
	'男',
	49,
	'',
	'5-11-2002 0:0:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'230202',
	'011073',
	'011073110007',
	'陈运生',
	'男',
	55,
	'',
	'7-11-2002 0:0:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'290201',
	'011046',
	'011046210030',
	'阮梦清',
	'男',
	69,
	'',
	'8-14-2002 0:0:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'300202',
	'011279',
	'011279210053',
	'杨承忠',
	'男',
	55,
	'',
	'1-13-2002 0:0:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0019',
	'100020101',
	'015033',
	'015033120017',
	'江友芬',
	'女',
	50,
	'',
	'6-21-2002 0:0:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0019',
	'100190203',
	'015033',
	'015033110014',
	'庞福记',
	'男',
	57,
	'',
	'11-13-2002 0:0:0.000',
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'768440203',
	'011078',
	'011078120101',
	'罗春',
	'女',
	27,
	'',
	'10-3-2002 0:0:0.000',
	'12-28-2002 11:26:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'684490204',
	'014098',
	'014098110001',
	'郭益宏',
	'男',
	33,
	'外二科',
	NULL,
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'788880205',
	'011069',
	'011069210025',
	'余明学',
	'男',
	70,
	'外科一区',
	'12-20-2002 11:38:0.000',
	'12-28-2002 14:52:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'791050201',
	'011082',
	'011082110089',
	'邱增强',
	'男',
	34,
	'内科一区',
	NULL,
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'718430201',
	'011291',
	'011291110034',
	'阮广其',
	'男',
	51,
	'内科三区',
	'12-20-2002 15:25:0.000',
	'12-28-2002 15:0:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'709880201',
	'011004',
	'011004210056',
	'吕祖森',
	'男',
	69,
	'脑系科',
	'12-20-2002 15:26:0.000',
	'12-31-2002 9:22:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'792290201',
	'014308',
	'014308110291',
	'谢秀文',
	'男',
	58,
	'内科三区',
	NULL,
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'792630201',
	'011290',
	'011290110075',
	'何国元',
	'男',
	53,
	'内科一区',
	NULL,
	'12-24-2002 10:3:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'792350201',
	'011078',
	'011078110078',
	'郑世全',
	'男',
	55,
	'脑系科',
	'12-24-2001 8:41:0.000',
	'12-28-2002 9:14:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'792760202',
	'014310',
	'014310110025',
	'陈德才',
	'男',
	53,
	'外科一区',
	NULL,
	'12-27-2002 10:28:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'775710202',
	'011078',
	'011078210390',
	'蓝炳富',
	'男',
	60,
	'内科一区',
	'12-24-2002 10:21:0.000',
	'12-31-2002 15:40:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'788550202',
	'017008',
	'017008210134',
	'陈道能',
	'男',
	67,
	'内科三区',
	NULL,
	'12-24-2002 14:52:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'792830201',
	'011299',
	'011299120040',
	'甘秀春',
	'女',
	37,
	'外科一区',
	'12-24-2002 16:28:0.000',
	'1-1-2003 9:45:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'791950201',
	'011087',
	'011087120033',
	'丘卫平',
	'女',
	38,
	'妇产科',
	NULL,
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'793260201',
	'012017',
	'012017210519',
	'陈从儒',
	'男',
	83,
	'脑系科',
	'12-25-2002 10:17:0.000',
	'12-29-2002 15:15:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'791530201',
	'017014',
	'017014210067',
	'陈后祺',
	'男',
	68,
	'内科三区',
	NULL,
	'12-25-2002 15:9:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'794850201',
	'014301',
	'014301110089',
	'王杨初',
	'男',
	58,
	'脑系科',
	NULL,
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'793720202',
	'018012',
	'018012220164',
	'林丽群',
	'女',
	52,
	'脑系科',
	NULL,
	NULL,
	0,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'793040201',
	'011202',
	'011202210021',
	'吕鹄飞',
	'男',
	71,
	'内科一区',
	'12-28-2002 10:2:0.000',
	'1-1-2003 14:48:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'756940202',
	'014144',
	'014144110019',
	'覃世升',
	'男',
	59,
	'脑系科',
	'12-28-2002 14:11:0.000',
	'1-1-2003 11:4:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'795000201',
	'014318',
	'014318110259',
	'杨玉冠',
	'男',
	61,
	'外科一区',
	NULL,
	NULL,
	0,
	1);
1234

⌨️ 快捷键说明

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