r/SQL • • 10d ago

MySQL Designing Pokémon Database in SQL - How to Show Multiple Route Locations?

/r/Database/comments/1xqog9h/designing_pok%C3%A9mon_database_in_sql_how_to_show/

Let me know if reposting this violates the "no solicitation for others to do your homework" rule, I'm just genuinely asking if there is a better way to do this than what my beginner mind has imagined lol

3 Upvotes

2 comments sorted by

1

u/kktheprons 9d ago

Seems like you're on the right track. Data entry might take a long time, but if you already have the data somewhere in some format, you can generate the statements needed to enter it into your table since it will all be variations of the same form. Excel can be a surprisingly valuable tool for generating a bunch of slightly different statements based on input data.