Get All MySql user list using command
Login using Below command
mysql -u root -p
After login type below command to know complete mysql User List
SELECT User, Host FROM mysql.user;
2 Column unique validation in controller in Laravel
Two Column unique validation in controller in Laravel In Laravel, ensuring a combination of two columns is unique within a database table often arises when dealing with complex data relationships, such as enforcing that a user can only have one role within a specific organization. This scenario cannot be directly handled through Laravel's standard unique validation rule, which traditionally operates on single fields. However, Laravel is flexible enough to accommodate this requirement through custom validation logic or advanced usage of its validation features. To implement a two-column unique validation in a Laravel controller, one effective method involves utilizing a combination of custom validation rules and querying the database to check for the existence of the specific combination of values. The approach involves creating a custom validation closure that leverages Laravel's Query Builder to search the relevant table for records matching both column values submitted by th
Comments
Post a Comment