How can I alter my table to not get this error

Asked Sep 26 '19 at 16:17

Active Sep 26 '19 at 16:22

Viewed 129 times

When I alter my table, I get an error:

1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

I've tried everything I could possibly think, please help.

ALTER TABLE property_rs_1
  ADD `LA3_PhoneNumber3Ext` varchar(5) DEFAULT NULL COMMENT 'LA3Agent Phone3 Extension',
  ADD `LA3_PhoneNumber4Desc` varchar(5) DEFAULT NULL COMMENT 'LA3AgentPhone4Description',
  ADD `LA3_PhoneNumber4CountryCodeId` varchar(50) DEFAULT NULL COMMENT 'LA3Agent Phone4 CountryId',
  ADD `LA3_PhoneNumber4` varchar(30) DEFAULT NULL COMMENT 'LA3Agent Phone4 Number',
  ADD `LA3_PhoneNumber4Ext` varchar(5) DEFAULT NULL COMMENT 'LA3Agent Phone4 Extension'

edited Sep 26 '19 at 16:22

Nigel Ren

56,122
11
43
55

asked Sep 26 '19 at 16:17

Edward

I think the error is very very clear about what you should do with your table structure – Sumit Wadhwa Sep 26 '19 at 16:19
2

And it looks like your table design is definetely not normalized and should be changed. – juergen d Sep 26 '19 at 16:19
Have a read of https://stackoverflow.com/questions/1258743/normalization-in-mysql and other resources about how to design your tables. – Nigel Ren Sep 26 '19 at 16:21

How can I alter my table to not get this error

0 Answers0