How many columns we can update in single MySQL query and What is maximum length of column name, table name and database name?

  • We can update maximum 64 columns in a single MySQL query.
  • A column name of MySQL table can be upto 64 characters.
  • A MySQL table name can be of 64 characters.
  • A MySQL database name can be of maximum 64 characters.

Share This: