In the world of database management systems, MySQL Insert Select is fastest tool to imports data from one table to another. MySQL has emerged as one of the most popular choices due to its reliability, performance, and ease of use. One of the powerful features it offers is the ability…
Category: Mysql
Ubuntu
How to Reset Root Password of MySQL 8 in Ubuntu 20.04 ?
Sometimes we forget or mistakenly type wrong password during the installation of mysql, So in this article i will help you to Reset Root Password of MySQL in Ubuntu 20.04. Mysql 8 has several new features and also it has change the default password algorithm for saving the password. Mysql…
how to add multiple select in laravel eloquent ?
Laravel eloquent builder has rich features to modify the query. In some cases we wanted to add multiple select in laravel and modify the select statement on basis of few conditions and wanted to add some select statement on condition. so in this article we will learn to add multiple…
Laravel
How to make database connection in Laravel 8 ?
Laravel comes with first party support for several database drivers. Laravel gives much better flexibility in terms of using the RDBMS based databases. Laravel supports MySQL, PostgreSQL, SQLite and SQL Server by default but if you want to make connection with Mongo or other database then you need to install…
Php
How to connect PHP to MySQL ?
PHP is commonly used in the world of web. PHP has many built in tools to connect with different drivers and in this tutorial we are going to use MySQL driver to connection between PHP and MySQL. There is two to connect database in PHP 5 and later version. MySQLi…
How to install MySQL in Ubuntu?
MySQL is a most popular and open source relational database. it provides multi user support with a many storage engines. in this tutorial we are going to install MySQL in Ubuntu. Let’s begin with simple steps: Step 1 : Open terminal in Ubuntu and install MySQL package Here, we are…
How to Import mysql database using command line?
Mysql has rich features for users like they can easily import and export database, create table, relations, store procedures, triggers etc. In the same way mysql has own command to import and export the mysql database. First find the mysql executable.you can open the terminal in ubuntu/Mac or command line…