Ruby Query MySQL Database
I have a sample table created in MySQL.
I have 3 functions
1. Connect to MySQL
2. Get all contacts
3. Insert contact
In my example, I am inserting 2 contacts and later retrieve the entire table of contacts.
You can pass in the db connection as a parameter if you prefer to share the connection. I did not do that in the example. Running the ruby script will generate the output below
If you have problem adding mysql2 library, it is probably you have not install it with gem. Read my Ubuntu Install Nokogiri article for instructions on how to install the library.