Category

Mysql

Category

The best way is to use IN statement : DELETE from tablename WHERE id IN (1,2,3,…,254); You can also use BETWEEN if you have consecutive IDs : DELETE from tablename WHERE id BETWEEN 1 AND 254; You can of course limit for some IDs using other WHERE clause : DELETE from tablename WHERE id BETWEEN 1 AND 254 AND id<>10;

1) What is the difference between NOW() and CURRENT_DATE()? Answer: Both NOW() and CURRENT_DATE() are built-in MySQL methods. NOW() is used to show the current date and time of the server and CURRENT_DATE() is used to show only the date of the server. SELECT now(); SELECT current_date(); 2) What is an index? How can an index be declared in MySQL? Answer: An index is a data structure of a MySQL table that is used to…

Step 1: Install Laravel Project I am going to install a laravel project using composer. composer create-project –prefer-dist laravel/laravel laravel7datatables Step 2: Going inside of project using the command cd laravel7datatables Step 3: Setup MySQL database Now, configure this database in the .env file. DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=laravel7datatables DB_USERNAME=root DB_PASSWORD=root@123 I have done local database credentials. Now migrate database php artisan migrate Step 4: Install yajra Package We going to install the yajra/laravel-datatables-oracle package by…

Ajax Autocomplete Search in Laravel 7 Step 1: Install laravel 7 using composer composer create-project –prefer-dist laravel/laravel laravel7search Step 2: Going inside of project using the command cd laravel7search Step 3: Setup MySQL database Now, configure this database in the .env file. DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=laravel7search DB_USERNAME=root DB_PASSWORD=root@123 Step 3: Create Migration and Model In this step, we have to create a migration for students table using Laravel 7 PHP artisan command, so first fire…

Hey, Reader Here, I will brief you step by step login with google account in Laravel 7 socialite. in Laravel 7 socialite provides API to login with Gmail account. I will help you step by step instruction. let’s follow the tutorial and implement it. Step 1: Install Laravel 7 I am going to install Laravel 7 projects. composer create-project –prefer-dist laravel/laravel googleLogin “7.*” Now I am going inside of the folder cd googleLogin Step 2:…

Step 1: Install Laravel 7 first of all, we need to get fresh Laravel 7 version application using bellow command, So open your terminal OR command prompt and run bellow command: laravel new laravel_blog Step 2: Database Configuration Open laravel_blog and set hostname, username, password and database name in .env file DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=laravel_blog DB_USERNAME=root DB_PASSWORD=root Step 3: Create Migration Now we are going to create a blog. so we have to create a…

Step 1: Install Laravel Project I am going to install a laravel project using composer. composer create-project –prefer-dist laravel/laravel laravel7datatables Step 2: Going inside of project using the command cd laravel7datatables Step 3: Setup MySQL database Now, configure this database in the .env file. DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=laravel7datatables DB_USERNAME=root DB_PASSWORD=root@123 I have done local database credentials. Now migrate database php artisan migrate Step 4: Install yajra Package We going to install the yajra/laravel-datatables-oracle package by…