• Home

MySQL

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 ... read on