This is the third part of the series where we create a service to interact with MySQL server in rails using mysql2 gem.

Requirements

• [x] Service to connect with external MySQL server
• [x] Perform basic query: select, insert and update
• [ ] Prepared statement
• [ ] Perform transaction
• [ ] Perform join query

In the previous two articles, we created a service and added methods to help us perform select, insert and update operations. Today we will be looking at performing prepared statements to MySQL server using mysql2 gem.

In this blog

We will be learning the following in this blog:

• Perform prepared statement

#mysql #rails #ruby