Exploring Invisible Columns in MySQL 8 and Laravel

Invisible columns, a new concept introduced in MySQL 8, offer an additional layer of security and control over sensitive data. When executing a SELECT * query, invisible columns are not retrieved by default. Instead, you must explicitly specify them in the SELECT statement. This ensures that sensitive information such as passwords, tokens, API keys, and payment-related data remains protected.

MySQL 8: Introduction to Invisible Columns

In MySQL 8, invisible columns are columns that are not included in the result set …

concept control data default information laravel mysql offer passwords query security select sensitive sensitive data sensitive information statement tokens