Error Code: 1118 Row Size too large
I am very new to MySQL. I am trying to create a new table with date/time and 300 columns of text.
CREATE TABLE `ai_location` (
`TimeStamp` datetime DEFAULT NULL,
`AI001` varchar(25) DEFAULT NULL,
`AI002` varchar(25) DEFAULT NULL,
.
.
.
`AI299` varchar(25) DEFAULT NULL,
`AI300` varchar(25) DEFAULT NULL)
300 x 25 = 7500.
Why do I get the following error??
Error Code: 1118 Row Size too large (> 8126).
Subject
Written By
Posted
Error Code: 1118 Row Size too large
May 01, 2023 06:25AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.