1. Select random rows from a table in MySQL

    In order to select a random row from MySQL, we can order the rows by a random number and then pick the first row.

    SELECT * FROM node ORDER BY rand() limit 1;

    The above query randomly selects a row from the table node.

    read on

  2. Resolve Net::MySQL Hang problem if the database result has only 1 row or is empty

    Net::MySQL is a simple MySQL perl Client to connect to MySQL servers. But Net::MySQL hangs if your result set is having just one row.

    Sample Net::MySQL code

    #!/usr/bin/perl use Net::MySQL; $mysql = Net::MySQL->new( hostname => 'localhost', database => 'db', user => 'user', password = … read on

On Facebook
Email Newsletter