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 […]
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 […]
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
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 […]
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 […]
Copyright © 2024 Rui Miguel Feio