Rui Miguel Feio

How to check who’s allocating a device unit

16th August 2009 Rui Miguel Feio

Let’s say for instance that you have a DASD volume (TSTCT1) and you would like to know who’s using it (allocating it). In order to do this we first need to know the unit address of said device: /D U,VOL=volume_name In our example: /D U,VOL=TSTCT1 Result: RESPONSE=TST1 IEE457I 09.53.10 UNIT […]

How to move a WordPress site to a different Server or URL

8th August 2009 Rui Miguel Feio

Moving a WordPress site from one server to another or to a different Web address (URL) may seem a daunting task and something to stay away from. The truth is that it is quite simple! Last month I was asked to help moving a WordPress (WP) blog from one server […]

How to select the First row from a MySQL table

6th July 2009 Rui Miguel Feio

You can use the following command to get the first row from a MySQL table: SELECT * FROM table LIMIT 1 Explanation: table – table name By limiting the returns to 1 (LIMIT 1) we get the first row from the table. Example: SELECT * FROM tusers LIMIT 1

How to select the Last row from a MySQL table

6th July 2009 Rui Miguel Feio

You can use the following command to get the last row from a MySQL table: SELECT * FROM table ORDER BY field DESC LIMIT 1 Explanation: table – table name field – table field This command orders the table by DESCENDING order and limits the number of rows returned to […]

Select random rows from a MySQL table

6th July 2009 Rui Miguel Feio

If you ever come across the need of randomly select rows from a MySQL table: SELECT * FROM table WHERE field1 = value ORDER BY RAND() LIMIT x Explanation: table – table name field1 – table field value – value you want field1 to be x – number of rows […]