开始SQL Server查询和MySQL插入测试
查询到38条记录
表结构: CompanyName_En, RegisteredAddress, ShopID, RegisteredAddress_En, LegalName, LegalPersonSurname_En, LegalPersonName_En, BirthDate, IDAddress, TelephoneNo, Email, VIESNumber, OtherCountrTax, FRRetailWholesale, ProductsRange, ShopLink, EORINumber, TaxEffectiveDate, BusinessLicense_Picture, LegalIDNumberPictureFront, LegalIDNumberPictureBack, BankName, AccountName, AccountNumber, IBANNumber, BICSWIFT, BankAddress, Currency, Attachment, CustomerID, OSSStart, CompanyRegistrationDate, RegistrationNo, RegisteredCapital, DeclarationMethod, AmazonSales, OtherSales, OtherCountryVAT, ID, Enabled, CreationDate, Creation_Id, CreationName, ModificationDate, Modification_Id, ModificationName, SortCode, CompanyCode, Company_ID, CompanyFullName, CompanyName, PinYin, PinYinShort, Auditor_ID, AuditorName, AuditStatus, Base_ShopInfoID, ShopName, Workflow_ID, BusinessLicense_PictureEn, LegalIDNumberPictureFrontEn, LegalIDNumberPictureBackEn, ArticlesAssociation_File, LegalPersonAddressProve_File, CompanyBankStatements_File, AmazonShop_Picture, TokenIDPicture, KeyMetricsPicture, TaxCertificate_File, BusinessCRFile, BusinessNNC1File, NationalStatutesFile, LegalSign, ContactPerson, ContactWeChat, CompanyIncorporationCountry, BusinessCode, RegisteredDate, LegalPersonFullNamePinYin, SirenNumber, TaxEmail, IDAddress_En, CompanyAddressLine1En, CompanyAddressLine2En, CompanyAddressProvinceEn, CompanyAddressCityEn, BoundZipCompanyPostCode, RoomNumber, RoomNumberSuffix, LegalPersonAddressLine1En, LegalPersonAddressLine2En, LegalPersonAddressCityEn, LegalPersonAddressProvinceEn, LegalPersonAddressPostCodeEn, LegalPersonCountry, LegalPersonRoomNumber, LegalPersonRoomNumberSuffix, LegalPersonGender, LegalPersonIDCardType, Nationality, RegisteredCapitalCurrency, CompanySignatureDate, LegalEmail, LegalPersonIdNumber, LegalPersonIdStartDate, LegalPersonIdEndDate, LegalForm, ServiceRemark, BusinessPlatform, NeedRequestEORI, HasNoOtherEORIOfEU

前1条记录:
记录 1: {"CompanyName_En":"91340802MA2WG3YD88","RegisteredAddress":"\u5b89\u5fbd\u7701\u5b89\u5e86\u5e02\u8fce\u6c5f\u533a\u4e34\u6e2f\u7ecf\u6d4e\u5f00\u53d1\u533a\u5185\u73af\u5357\u8def8\u53f7","ShopID":"9f17a4ed-2307-4605-bd9c-0bfa392a233b","RegisteredAddress_En":"lingang jingji kaifa qu nei huan nan lu 8 hao","LegalName":"\u9ece\u6842\u82b3","LegalPersonSurname_En":null,"LegalPersonName_En":null,"BirthDate":"1964-11-29 00:00:00.000","IDAddress":"dan zao zhen shang an bai sha cun cun qian jie shi yi xiang 2 haodan zao zhen,fo shan shi,guang dong sheng,528216,CN","TelephoneNo":"+86-22222","Email":"88289586@qq.com","VIESNumber":"","OtherCountrTax":null,"FRRetailWholesale":null,"ProductsRange":"111111","ShopLink":"https:\/\/www.amazon.com\/sp?ie=UTF8&seller=A205G5V4CH6CWD&asin=B0C2P8Y474&ref_=dp_merchant_link&isAmazonFulfilled=1","EORINumber":"","TaxEffectiveDate":"2025-12-01 00:00:00.000","BusinessLicense_Picture":"f764257f-75e8-4ba7-b39a-33d8d092b224","LegalIDNumberPictureFront":"96632b69-c4ed-45eb-b427-99707cb32531","LegalIDNumberPictureBack":"bd66a088-d5c6-40b8-a144-8eb1f23b5dde","BankName":null,"AccountName":null,"AccountNumber":null,"IBANNumber":null,"BICSWIFT":null,"BankAddress":null,"Currency":null,"Attachment":"543620c6-be10-c727-ccbf-b8424a126a4d","CustomerID":"","OSSStart":null,"CompanyRegistrationDate":null,"RegistrationNo":"91340802MA2WG3YD88","RegisteredCapital":"80000.00","DeclarationMethod":"0","AmazonSales":"1111111","OtherSales":"","OtherCountryVAT":"","ID":"03a7855b-ac14-483a-850e-c7383bccfbfc","Enabled":"1","CreationDate":"2026-01-14 19:36:13.767","Creation_Id":"14c9f59c-dfb2-4389-b5d7-330f6235d241","CreationName":"13480680000","ModificationDate":"2026-01-14 19:41:23.000","Modification_Id":"System","ModificationName":"\u8d85\u7ea7\u7ba1\u7406\u5458","SortCode":null,"CompanyCode":null,"Company_ID":"c864b4bc-22f5-4e3c-93b4-2d3e6a6e8a5d","CompanyFullName":null,"CompanyName":null,"PinYin":null,"PinYinShort":null,"Auditor_ID":null,"AuditorName":null,"AuditStatus":null,"Base_ShopInfoID":null,"ShopName":null,"Workflow_ID":"","BusinessLicense_PictureEn":null,"LegalIDNumberPictureFrontEn":null,"LegalIDNumberPictureBackEn":null,"ArticlesAssociation_File":null,"LegalPersonAddressProve_File":null,"CompanyBankStatements_File":null,"AmazonShop_Picture":null,"TokenIDPicture":null,"KeyMetricsPicture":null,"TaxCertificate_File":"","BusinessCRFile":"","BusinessNNC1File":"","NationalStatutesFile":"wu_1jeu4ukvsg2d19pltf8ln1e9b1i","LegalSign":"5d7d3f30-0b68-4f91-8a0c-1406710e884c","ContactPerson":"444","ContactWeChat":null,"CompanyIncorporationCountry":"\u4e2d\u56fd","BusinessCode":"","RegisteredDate":"2020-12-01 00:00:00","LegalPersonFullNamePinYin":"GUI FANG LI","SirenNumber":null,"TaxEmail":"4444@qq.com","IDAddress_En":"dan zao zhen shang an bai sha cun cun qian jie shi yi xiang 2 haodan zao zhen,fo shan shi,guang dong sheng,528216,CN","CompanyAddressLine1En":"lingang jingji kaifa qu","CompanyAddressLine2En":"lingang jingji kaifa qu nei huan nan lu 8 hao","CompanyAddressProvinceEn":"an hui sheng","CompanyAddressCityEn":"an qing shi","BoundZipCompanyPostCode":"246000","RoomNumber":"8","RoomNumberSuffix":"hao","LegalPersonAddressLine1En":"dan zao zhen","LegalPersonAddressLine2En":"dan zao zhen shang an bai sha cun cun qian jie shi yi xiang 2 hao","LegalPersonAddressCityEn":"fo shan shi","LegalPersonAddressProvinceEn":"guang dong sheng","LegalPersonAddressPostCodeEn":"528216","LegalPersonCountry":"CN","LegalPersonRoomNumber":"2","LegalPersonRoomNumberSuffix":"hao","LegalPersonGender":null,"LegalPersonIDCardType":null,"Nationality":"HAN","RegisteredCapitalCurrency":"CNY","CompanySignatureDate":"2024-12-23 00:00:00","LegalEmail":null,"LegalPersonIdNumber":"44062219641129178X","LegalPersonIdStartDate":"2025-04-27 00:00:00","LegalPersonIdEndDate":"2099-01-01 00:00:00","LegalForm":null,"ServiceRemark":null,"BusinessPlatform":null,"NeedRequestEORI":null,"HasNoOtherEORIOfEU":null}
... 还有37条记录未显示
正在连接MySQL数据库...
MySQL连接错误: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)
错误代码: 1045
测试结束