Data exploration
Jump to navigation
Jump to search
Maximum length of characters in a column
- Excel: =MAX(LEN(Sheet1!A2:Sheet1!A1048576)) where 1048576 is the rows limit of Excel spreadsheet[1].
- MySQL: Using LENGTH() function e.g. <nowiki=SELECT MAX(LENGTH(`my_column`)) FROM `my_table`</nowiki> cf: MySQL CHAR_LENGTH() function - w3resource
references