· 8 years ago · Jun 23, 2018, 01:46 AM
1drop table if exists foo;
2
3create table foo
4(
5foo varchar(65535)
6);
7
8MySQL Database Error: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535.
9You have to change some columns to TEXT or BLOBs
10
11drop table if exists foo;
12
13create table foo
14(
15foo varchar(65532)
16);
17
18Executed Successfully
19
20drop table if exists foo;
21
22create table foo
23(
24id int,
25foo varchar(65532)
26);
27
28MySQL Database Error: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535.
29You have to change some columns to TEXT or BLOBs