Using Python to execute MySQL Insert and Update queries

There are requirements at times where we have to execute the queries on the Prod database which changes the data in the table i.e insert & update queries. While inserting could be a straightforward case as the number of record is known same can't be said for UPDATE queries as the number of effected rows … Continue reading Using Python to execute MySQL Insert and Update queries

MySQL query with the conditions as ‘NOT LIKE IN’

While working with MySQL database i needed to write a query which will exclude rows where a column contains one or more words from a set of words. i.e I want to fetch data from student from table where name doesn't contain words shashank,john etc. Initially i was trying to write a query like this  : … Continue reading MySQL query with the conditions as ‘NOT LIKE IN’