Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How many columns can you have (maximum) in a MySQL table?

Tags:

mysql

What's the max number of columns a mysql table can have?

like image 380
Ali Avatar asked Nov 11 '09 04:11

Ali

1 Answers

According to the MySQL Reference Manual, there is a "hard limit" of 4,096 columns per table.

Check the following link for more information.

like image 182
Edward Avatar answered Sep 29 '22 09:09

Edward
Sign in to Comment

Related questions

Impossible MySQL insert ... select foreign key constraint error‽
File uploads slower than user's network upload speed on Apache (EC2)
Only half of the MongoDB database is being processed in Spring batch
SQLAlchemy - bulk insert ignore: "Duplicate entry"
MySQL Selecting Info based on timestamp of another table
The same response for the second table
Generate MySQL JSON_EXTRACT condition with user search parameter
Config apartment-gem for MySQL using structure.sql instead of schema.rb to create a new tenant
Hibernate not getting correct records using query.list();
Server Side Events with PHP & MySQL
Spark: Reading big MySQL table into DataFrame fails
Database user with global privileges does not have access to newly created database
Finding nearest places using point datatype and st_distance_sphere in MySQL 8
How to store Linked Tree with children in Relational Database?
State "Waiting for table flush" in processlist
mariadb:Couldn't execute 'SHOW PACKAGE STATUS WHERE Db='db_name'
is there any way to show MySQL table lock history
Merge two tables in one SQL query and make the date values unique
Partial update of JSON Object in MySQL
Django: How can you stop long queries from killing your database? [closed]

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!