- 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.
More from my site
How to delete duplicate records from MySQL table | MySQL query to delete duplicate records
Second Highest Salary without subquery in MySQL | Nth highest Salary without subquery | MySQL second highest salary query
How to use multiple MySql database in PHP, MYSQLi & PDO
Export To Excel with Headers In PHP and MySQL | How to Export MySQL Data in Excel/CSV File using PHP/MySQL
Batch update in php mysql- Laravel Migration Example | Database: Migrations – Laravel | Laravel 5.5 Migration Tutorial | Database Versioning
