Is there a way to get the max,count, or etc for all columns without naming them individually?
https://mariadb.com/kb/en/library/procedure-analyse/  (Also works in MySQL.)

SELECT * FROM blah PROCEDURE ANALYSE();


For example, using a table of Canadian cities; notice the min and max values:

mysql&gt; SELECT * FROM canada PROCEDURE ANALYSE()\G
*************************** 1. row ***************************
             Field_name: world.canada.id
              Min_value: 291724
              Max_value: 297207
             Min_length: 6
             Max_length: 6
       Empties_or_zeros: 0
                  Nulls: 0
Avg_value_or_avg_length: 294465.5000
                    Std: 1583.0944
      Optimal_fieldtype: MEDIUMINT(6) UNSIGNED NOT NULL
*************************** 2. row ***************************
             Field_name: world.canada.country
              Min_value: ca
              Max_value: ca
             Min_length: 2
             Max_length: 2
       Empties_or_zeros: 0
                  Nulls: 0
Avg_value_or_avg_length: 2.0000
                    Std: NULL
      Optimal_fieldtype: ENUM('ca') NOT NULL
*************************** 3. row ***************************
             Field_name: world.canada.ascii_city
              Min_value: 
              Max_value: zehner
             Min_length: 0
             Max_length: 42
       Empties_or_zeros: 1
                  Nulls: 0
Avg_value_or_avg_length: 10.0376
                    Std: NULL
      Optimal_fieldtype: VARCHAR(42) NOT NULL
*************************** 4. row ***************************
             Field_name: world.canada.city
              Min_value: (dup population)
              Max_value: Zehner
             Min_length: 1
             Max_length: 31
       Empties_or_zeros: 3
                  Nulls: 0
Avg_value_or_avg_length: 9.7861
                    Std: NULL
      Optimal_fieldtype: TINYTEXT NOT NULL
*************************** 5. row ***************************
             Field_name: world.canada.state
              Min_value: 
              Max_value: 14
             Min_length: 0
             Max_length: 2
       Empties_or_zeros: 1
                  Nulls: 0
Avg_value_or_avg_length: 1.9996
                    Std: NULL
      Optimal_fieldtype: ENUM('','01','02','03','04','05','07','08','09','10','11','12','13','14') NOT NULL
*************************** 6. row ***************************
             Field_name: world.canada.population
              Min_value: 540
              Max_value: 4612187
             Min_length: 3
             Max_length: 7
       Empties_or_zeros: 4771
                  Nulls: 0
Avg_value_or_avg_length: 4300.6415
                    Std: 85242.3200
      Optimal_fieldtype: MEDIUMINT(7) UNSIGNED NOT NULL
*************************** 7. row ***************************
             Field_name: world.canada.lat
              Min_value: 0
              Max_value: 82.4832992553711
             Min_length: 1
             Max_length: 7
       Empties_or_zeros: 1
                  Nulls: 0
Avg_value_or_avg_length: 50.09833726667297
                    Std: 5.212114845361912
      Optimal_fieldtype: FLOAT NOT NULL
*************************** 8. row ***************************
             Field_name: world.canada.lng
              Min_value: -140.98300170898438
              Max_value: 0
             Min_length: 1
             Max_length: 8
       Empties_or_zeros: 1
                  Nulls: 0
Avg_value_or_avg_length: -89.74846842687205
                    Std: 23.8526411452119
      Optimal_fieldtype: FLOAT NOT NULL
*************************** 9. row ***************************
             Field_name: world.canada.stripe
              Min_value: 0
              Max_value: 1190
             Min_length: 1
             Max_length: 4
       Empties_or_zeros: 1
                  Nulls: 0
Avg_value_or_avg_length: 966.6869
                    Std: 37.9899
      Optimal_fieldtype: SMALLINT(4) UNSIGNED NOT NULL
*************************** 10. row ***************************
             Field_name: world.canada.province
              Min_value: Alberta
              Max_value: Yukon
             Min_length: 5
             Max_length: 25
       Empties_or_zeros: 0
                  Nulls: 0
Avg_value_or_avg_length: 10.9220
                    Std: NULL
      Optimal_fieldtype: ENUM('Alberta','British Columbia','Manitoba','New Brunswick','Newfoundland and Labrador','Northwest Territories','Nova Scotia','Nunavut','Ontario','Prince Edward Island','Quebec','Saskatchewan','Yukon') NOT NULL
10 rows in set (0.04 sec)