我跟踪前段应用,跟踪的出sql是这样的:Insert Into "PAT_MASTER_INDEX" ( "PATIENT_ID" , "INP_NO" , "NAME" ,
"NAME_PHONETIC" , "SEX" , "DATE_OF_BIRTH" , "BIRTH_PLACE" , "CITIZENSHIP" ,
"NATION" , "ID_NO" , "IDENTITY" , "CHARGE_TYPE" , "UNIT_IN_CONTRACT" ,
"MAILING_ADDRESS" , "ZIP_CODE" , "PHONE_NUMBER_HOME" ,
"PHONE_NUMBER_BUSINESS" , "NEXT_OF_KIN" , "RELATIONSHIP" ,
"NEXT_OF_KIN_ADDR" , "NEXT_OF_KIN_ZIP_CODE" , "NEXT_OF_KIN_PHONE" ,
"LAST_VISIT_DATE" , "VIP_INDICATOR" , "CREATE_DATE" , "OPERATOR" ,
"PATIENT_CLASS" )
Values
( :1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 ,
:15 , Null , Null , :16 , :17 , :18 , :19 , :20 , Null , 2 , :21 , :22 ,
:23 )
请问 ( :1 , :2 , :3 , :4 , :5 .....这些冒号数字是什么意思?SQL
"NAME_PHONETIC" , "SEX" , "DATE_OF_BIRTH" , "BIRTH_PLACE" , "CITIZENSHIP" ,
"NATION" , "ID_NO" , "IDENTITY" , "CHARGE_TYPE" , "UNIT_IN_CONTRACT" ,
"MAILING_ADDRESS" , "ZIP_CODE" , "PHONE_NUMBER_HOME" ,
"PHONE_NUMBER_BUSINESS" , "NEXT_OF_KIN" , "RELATIONSHIP" ,
"NEXT_OF_KIN_ADDR" , "NEXT_OF_KIN_ZIP_CODE" , "NEXT_OF_KIN_PHONE" ,
"LAST_VISIT_DATE" , "VIP_INDICATOR" , "CREATE_DATE" , "OPERATOR" ,
"PATIENT_CLASS" )
Values
( :1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 ,
:15 , Null , Null , :16 , :17 , :18 , :19 , :20 , Null , 2 , :21 , :22 ,
:23 )
请问 ( :1 , :2 , :3 , :4 , :5 .....这些冒号数字是什么意思?SQL
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货