O'Reilly logo

MariaDB Cookbook by Daniel Bartholomew

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Updating and deleting data using HandlerSocket and Ruby

Updating and deleting data is similar to but not quite the same as inserting data. In this recipe, we will use Ruby and HandlerSocket to update and delete data.

Getting ready

Complete the Inserting data using HandlerSocket and Ruby recipe prior to starting this recipe.

How to do it...

  1. Launch the interactive Ruby interpreter in a terminal window as follows:
    irb
    
  2. Run the following commands in the irb interpreter to open a HandlerSocket connection to our test database and the hs_test table:
    require 'rubygems'
    require 'handlersocket'
    hsu = HandlerSocket.new(:host => '127.0.0.1',:port => '9999')
    hsu.open_index(2,'test','hs_test','PRIMARY','givenname')
    
  3. Then, update a row in the interpreter using the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required