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: