TutorialMySQL
MySQL JSON columns: index, query and validate them properly
Store flexible data in MySQL 8.4 JSON columns without slow queries: generated-column and functional indexes, JSON_TABLE, partial updates and schema checks.
By Cloudsoft Zone
Topic
29 articles
Troubleshooting guideMySQL
Fix MySQL 'Incorrect string value' errors by moving to utf8mb4
Why MySQL rejects emoji with error 1366, how to find utf8mb3 columns, convert tables and connections to utf8mb4, and avoid key-length and collation errors.
By Cloudsoft Zone
TutorialMySQL
Connect to a MySQL database from the command line, safely
Connect to MySQL 8.4 or 9.7 with the mysql client and MySQL Shell: socket versus TCP, verified TLS, option files, login paths, scripting, and fixes for common errors.
By Cloudsoft Zone
Interview preparationInterview questions
WordPress interview questions and answers for WordPress 7
Forty-two WordPress interview questions answered for WordPress 7.1: posts and taxonomies, roles, themes, hooks, the Loop, database tables, security, performance, REST API and blocks.
By Cloudsoft Zone
Interview preparationInterview questions
Magento 2 interview questions and answers for Magento 2.4.9
Fifty Magento interview questions answered for Magento Open Source and Adobe Commerce 2.4.9: EAV, ORM, DI, plugins, layout, caching, indexers, APIs, security and what Magento 1 answers changed.
By Cloudsoft Zone
Showing 5 articles