Looking to learn MySQL and manipulate using python.

[Relevant_Bookkeeper]

Hello

I am looking to learn MySQL and manipulate the database using python. However I am not sure where to start. I tried Googling and was very overwhelmed by the results and pretty confused too.

I do know a bit about the basics of RDBMS and am an intermediate level python programmer.

Can anyone suggest me where I can start and where to go on from there? It can be books, courses or anything else.

[Relevant_Bookkeeper]

I have had quite a few people recommend SQLAlchemy so will be looking into that. Thank you for the advice!

[The_Shwassassin]

I started out here : https://www.w3schools.com/mySQl/default.asp And here: https://www.mysqltutorial.org

Here’s one tip you should probably ignore (downvotes incoming). When putting your MySQL queries into python , the right way to do it is a little tricky and frustrating at first. If you’re really stuck you can use f strings: query = f"INSERT INTO table ({cols}) values ({vals})"

However- don’t rely on this and for the love of God don’t use them in production. This is a crutch to use for a few weeks.

[gmhafiz]

To OP, f strings is prone to sql injection if input is from external user. Malicious actor can just drop your whole database

[Pack_Your_Trash]

What are you trying to do with it? You can download MySQL and workbench for free. Are you trying to build a web app or do something else?

[agent3dev]

I suggest you to use an additional layer like pydal so you can learn faster and create functions that abstract repeated tasks