1DROP TABLE IF EXISTS t1; 2CREATE TABLE t1 (c CHAR <CUSTOM_COL_OPTIONS>, 3c0 CHAR(0) <CUSTOM_COL_OPTIONS>, 4c1 CHAR(1) <CUSTOM_COL_OPTIONS>, 5c20 CHAR(20) <CUSTOM_COL_OPTIONS>, 6c255 CHAR(255) <CUSTOM_COL_OPTIONS> 7) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>; 8SHOW COLUMNS IN t1; 9Field Type Null Key Default Extra 10c char(1) # # # 11c0 char(0) # # # 12c1 char(1) # # # 13c20 char(20) # # # 14c255 char(255) # # # 15INSERT INTO t1 (c,c0,c1,c20,c255) VALUES ('','','','',''); 16INSERT INTO t1 (c,c0,c1,c20,c255) VALUES ('a','','b','abcdefghi klmnopqrst', 'Creating an article for the Knowledgebase is similar to asking questions. First, navigate to the category where you feel the article should be. Once there, double check that an article doesn\'t already exist which would work.'); 17SELECT c,c0,c1,c20,c255 FROM t1; 18c c0 c1 c20 c255 19 20a b abcdefghi klmnopqrst Creating an article for the Knowledgebase is similar to asking questions. First, navigate to the category where you feel the article should be. Once there, double check that an article doesn't already exist which would work. 21INSERT INTO t1 (c,c0,c1,c20,c255) VALUES ('abc', 'a', 'abc', REPEAT('a',21), REPEAT('x',256)); 22Warnings: 23Warning 1265 Data truncated for column 'c' at row 1 24Warning 1265 Data truncated for column 'c0' at row 1 25Warning 1265 Data truncated for column 'c1' at row 1 26Warning 1265 Data truncated for column 'c20' at row 1 27Warning 1265 Data truncated for column 'c255' at row 1 28INSERT INTO t1 (c,c0,c1,c20,c255) SELECT c255, c255, c255, c255, CONCAT(c255,c1) FROM t1; 29Warnings: 30Warning 1265 Data truncated for column 'c' at row 2 31Warning 1265 Data truncated for column 'c0' at row 2 32Warning 1265 Data truncated for column 'c1' at row 2 33Warning 1265 Data truncated for column 'c20' at row 2 34Warning 1265 Data truncated for column 'c' at row 3 35Warning 1265 Data truncated for column 'c0' at row 3 36Warning 1265 Data truncated for column 'c1' at row 3 37Warning 1265 Data truncated for column 'c20' at row 3 38Warning 1265 Data truncated for column 'c255' at row 3 39SELECT c,c0,c1,c20,c255 FROM t1; 40c c0 c1 c20 c255 41 42 43C C Creating an article Creating an article for the Knowledgebase is similar to asking questions. First, navigate to the category where you feel the article should be. Once there, double check that an article doesn't already exist which would work.b 44a a aaaaaaaaaaaaaaaaaaaa xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 45a b abcdefghi klmnopqrst Creating an article for the Knowledgebase is similar to asking questions. First, navigate to the category where you feel the article should be. Once there, double check that an article doesn't already exist which would work. 46x x xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 47SELECT DISTINCT c20, REPEAT('a',LENGTH(c20)), COUNT(*) FROM t1 GROUP BY c1, c20; 48c20 REPEAT('a',LENGTH(c20)) COUNT(*) 49 2 50Creating an article aaaaaaaaaaaaaaaaaaa 1 51aaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaa 1 52abcdefghi klmnopqrst aaaaaaaaaaaaaaaaaaaa 1 53xxxxxxxxxxxxxxxxxxxx aaaaaaaaaaaaaaaaaaaa 1 54ALTER TABLE t1 ADD COLUMN c257 CHAR(257) <CUSTOM_COL_OPTIONS>; 55ERROR 42000: Column length too big for column 'c257' (max = 255); use BLOB or TEXT instead 56DROP TABLE t1; 57