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:

Leave a Reply

Your email address will not be published. Required fields are marked *