set maximum length of string mysql code example Example: max length found in mysql SELECT city, max(length(city)) FROM Customers;