- 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
-
Second Highest Salary without subquery in MySQL | Nth highest Salary without subquery | MySQL second highest salary query
-
How to delete duplicate records from MySQL table | MySQL query to delete duplicate records
-
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
-
TypeScript Interfaces | Why use interfaces in angular typescript
-
Batch update in php mysql