I'm running a database on AWS Lightsail and I have a bunch of .txt files I want to import into the database. I can't merge the files because I want to create one table per text file (table name = txt file name).
Is there a quick way to do this other than using the import wizard and importing one-by-one?
Here's the format of the text files (id:firstname:lastname)
10000:john:smith 10001:alice:wonder 10002:mark:asdf
9878665:joe:cheerio 9878666:player:one 9878667:yolo:swag
So ideally it would create a table called
textfile2, and so forth. All these txt files are just in a single folder.
How can I automate this?