Category

Mysql

Category

InnoDB vs MyISAM The main differences between both Engine InnoDB and MyISAM InnoDB has row-level locking. MyISAM only has full table-level locking.InnoDB has what is called referential integrity which involves supporting foreign keys (RDBMS) and relationship constraints, MyISAM does not (DMBS).InnoDB supports transactions, which means you can commit and roll back. MyISAM does not.InnoDB is more reliable as it uses transactional logs for auto recovery. MyISAM does not.

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…