Have you ever had to type out a massive CREATE TABLE
statement by hand? One with dozens of columns? Maybe several
dozens of columns? There are likely some GUI tools to help with
large CREATE TABLE commands. Or, other
drag-n-drop types of software that I am not familiar
with. What if you could write a few lines of Python code and take
care of a huge CREATE TABLE statement with way less
effort than typed manually? Interested? Continue reading
and see how using pandas, pyodbc, and MySQL…
Photo by Vorsen Furniture on Unsplash
OS, Software, and DB used:
- OpenSuse Leap 15.1 …