MySQL Prepared Statements are the queries or statements they are prepared in a way that they can be used later on. They are complied while on creation and can be executed later as desired. We might need to run prepared statements many times once its created. Lets get little bit deep into it and how […]
mysql
MySQL: Triggers
Triggers in MySQL and SQL Triggers in SQL is a way to invoke something as a response to the events on the table in which Trigger is attached. The example of the event can be Insert, Update, Delete. Triggers are of two type, Row Level and Statement Level. The row level trigger is triggered for […]
Running Airflow in WSL but Using MySQL Server from Windows as Default
Introduction There are lots of benefit of using MySQL as a backend database in Airflow. Main reason is that MySQL is widely used in production instead of SQlite. Also, we can have scalable database system where we can have concurrent requests, high security and well defined permission and roles. From the last few blogs, I’ve […]
Connecting to MySQL Server in Windows Machine from WSL
Connecting MySQL Server in Windows Machine from WSL What does this mean? In simple sentence, how do we connect to a MySQL server which is hosted in Windows from WSL. It might sound easy but let me tell you, IT IS NOT!!!! I was trying to connect (from WSL) to my local MySQL which was […]