show

How to list certain installed packages on Debian Linux.

by

The dpkg command can be used to list all installed packages. I wanted to list the language packs installed with Firefox. So the command below is perfect. jason@Yog-Sothoth:~$ dpkg –list firefox-locale-* Desired=Unknown/Install/Remove/Purge/Hold | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad) ||/ Name Version Architecture Description +++-==============================-====================-====================-================================================================== ii firefox-locale-de 75.0+build3-0ubuntu0 amd64 German language pack for Firefox ii firefox-locale-en … Read more

How to list the various network devices on your Linux system and show the traffic rates.

by

List the network devices on your system easily The ethstats command available on a Linux system allows you to show the network interfaces installed in your machine and the data transfer rates if they are connected to a network and they are not idle. Install this script using this command. ubuntu ~ $ sudo apt … Read more

How to list the indexes in a MySQL database table.

by

How to list the indexes in a MySQL database table. Easily done using the show command. mysql> show index from customer; +———-+————+——————-+————–+——————–+———–+————-+———-+——–+——+————+———+—————+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +———-+————+——————-+————–+——————–+———–+————-+———-+——–+——+————+———+—————+ | customer | 0 | … Read more

More MySQL tips. Listing databases and viewing the MySQL version.

by

How to list tables in a MySQL database. mysql> show tables in acme; +—————-+ | Tables_in_acme | +—————-+ | address | | customer | | discount | | order_header | | order_line | | order_shipment | | payment_terms | | phone | | product | | reseller | | salesman | | shipment | | … Read more