Use Python to dynamically generate SQL statements for creating tables (using Pandas Library) according to the attribute table excel file of a specific format

Problem description There are 33 national standard attribute table excel files, and the database table needs to be built according to these standard attribute tables. The format of each excel is as follows: For such heavy and basically brainless work, I choose Python to do it: code import pandas import re def getStandardDataType(x): ...

Posted by LiamOReilly on Sat, 26 Mar 2022 06:52:41 +0300