Data exploration

Maximum length of characters in a column

• Excel: =MAX(LEN(Sheet1!A2:Sheet1!A1048576)) where 1048576 is the rows limit of Excel spreadsheet.
• MySQL: Using LENGTH() function e.g. <nowiki=SELECT MAX(LENGTH(`my_column`)) FROM `my_table`</nowiki> cf: MySQL CHAR_LENGTH() function - w3resource

references

This article "Data exploration" is still being written. If there are any incomplete parts, you are welcome to directly edit them. 這篇文章「Data exploration」內容還在撰寫中，如果有不完整的部分，歡迎你直接動手修改。