The total size of all fields in the table is more than the limit, 65535, that’s why you are getting this error.
You should use text
type instead of varchar
for long strings. Replace all varchar(8000)
with text
, and it should work.
Or, even better, use appropriate data types instead of the “too large” ones. You don’t really need 8000 characters to store currency
, do you?
Related Contents:
- ‘IF’ in ‘SELECT’ statement – choose output value based on column values
- How do I set the time zone of MySQL?
- Update a column value, replacing part of a string
- #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
- Why can’t a text column have a default value in MySQL?
- Binary Data in MySQL [closed]
- Why there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT clause?
- SQL order string as number
- MySQL, Check if a column exists in a table with SQL
- mysql: see all open connections to a given database?
- MySQL Multiple Joins in one query?
- MySQL: Fastest way to count number of rows
- Create an index on a huge MySQL production table without table locking
- How to make Sequelize use singular table names
- How to import an excel file in to a MySQL database
- With MySQL, how can I generate a column containing the record index in a table?
- mysqldump – Export structure only without autoincrement
- Show tables by engine in MySQL
- Simple Random Samples from a MySQL Sql database
- Update date + one year in mysql
- MySQL lowering wait_timeout value to lower number of open connections
- What’s a secure alternative to using a MySQL password on the command line?
- With MySQL, how long does an “ALTER TABLE … DISABLE KEYS;” statement last?
- dump all mysql tables into separate files automatically?
- Select from multiple tables without a join?
- Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?
- Create a Cumulative Sum Column in MySQL
- Replace null with 0 in MySQL
- Get the latest date from grouped MySQL data
- sql error errno: 121
- MySQL delete multiple rows in one query conditions unique to each row
- Looping Over Result Sets in MySQL
- Should I COUNT(*) or not?
- MySQL stored procedures use them or not to use them
- MySQL: Delete all rows older than 10 minutes
- Continue SQL query even on errors in MySQL workbench
- restart mysql server on windows 7
- delete all record from table in mysql [closed]
- Why is SQLAlchemy count() much slower than the raw query?
- Database design: 3 types of users, separate or one table? [closed]
- How do I do a fuzzy match of company names in MYSQL with PHP for auto-complete?
- How can I describe all tables in the database through one statement?
- Are UNIQUE indices case sensitive in MySQL?
- MySQL explain Query understanding
- MySQL: Simple way to toggle a value of an int field
- Create mysql database and user in bash script
- Storing IPv6 Addresses in MySQL
- Amazon RDS Aurora vs RDS MySQL vs MySQL on EC2?
- Characters “ي” and “ی” and the difference in persian – Mysql
- In SQL, is it OK for two tables to refer to each other?