Learn With Rana

Most Common SQL Commands Every Developer Should Know SQL (Structured Query Language) is the foundation of working with databases. Whether you're a backend developer, full-stack engineer, or data analyst — knowing how to write SQL queries is a must-have skill. In this post, we’ll go over the most commonly used SQL commands that every developer should know with examples. Let’s get started! 1. SELECT – Retrieve Data This is the most basic and widely used SQL command. SELECT * FROM users; Retrieve all columns from the users table. 2. INSERT INTO – Add Data INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com'); Adds a new record to the users table. 3. UPDATE – Modify Existing Records UPDATE users SET name = 'Jane Doe' WHERE id = 1; Updates the name of the user whose ID is 1. 4. DELETE – Remove Records DELETE FROM users WHERE id = 2; Deletes the user with ID 2 from the t...

Conditional Migration in Laravel 11 Using shouldRun() Laravel 11 introduces a powerful feature: the shouldRun() method in migration classes. It allows you to conditionally execute a migration based on custom logic. This is especially useful when: ✅ You want to avoid duplicate column additions. ✅ Your migration depends on the presence of another table. ✅ You want to ensure foreign keys or indexes don’t already exist. 🛠️ Step 1: Install Laravel 11 composer create-project "laravel/laravel:^11.0" conditional-migration 🗄️ Step 2: Configure Database DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=your_database_name DB_USERNAME=your_username DB_PASSWORD=your_password 📦 Step 3: Run Default Migrations php artisan migrate ✏️ Step 4: Create a New Migration php artisan make:migration add_profile_completed_to_users_table Edit the migration file to use shouldRun() : public function shoul...