phprockers-logo

Limitatin in MYSQL

Table attribute names are eliminated after 31 characters in the database.

The maximum character of database and table is 122 characters in the mysql.

The maximum number of table in a mysql database is 1792.

The maximum number of database in mysql is 20320.

The maximum number of attributes (that is, columns and indexes) per table is 128 characters.

The maximum number of attributes per key is 32.

The maximum permitted size of one row in table is 8052 bytes.

0 comments:

Post a Comment