Facts for developer

A stored procedure is a segment of declarative SQL statements stored inside the database catalog. A stored procedure can be invoked by triggers, other stored procedures, and applications such as Java, Python, PHP. In a simple language its classes for the sql and we can use this for long term goal A stored procedure that calls itself is known as a recursive stored procedure. Most database management systems support recursive stored procedures. However, MySQL does not support it very well. You should check your version of MySQL database before implementing recursive stored procedures in MySQL. Stored Procedures in MySQL MySQL is known as the most popular open source RDBMS which is widely used by both community and enterprise. However, during the first decade of its existence, it did not support stored procedures, stored functions, triggers, and events. Since MySQL version 5.0, those features were added to the MySQL database engine to mak...

In this tutorial, we’re going to explain how to integrate LinkedIn login in Laravel based application using Socialite. The Socialite is Laravel’s official package, which is making is easy to authenticate with external services with OAuth providers. Create Project Create a brand new Laravel 5.6 project with Composer create-project command: $ composer create - project laravel / laravel factdeveloper - linkedIn - login 5.6 -- prefer - dist Database connection settings After creating project open .env file and update your database credentials: . . . DB_CONNECTION = mysql DB_HOST = 127.0.0.1 DB_PORT = 3306 DB_DATABASE = factdeveloper_linkedin_login DB_USERNAME = root DB_PASSWORD = mysql . . . Next step, would be, go to the project root and open the terminal and type the following command. It will create the two tables, which is by default ships by Laravel 5.6 $ php artisan migrate Migration table created succe...