Tech tutorials, How To's & User guides

MENUMENU
  • Linux
  • Ubuntu
  • Python
  • NodeJS
  • Apache
  • Nginx
  • Website Administration
    • PHP
    • Django
  • Git

MySQL

MySQL INSERT or UPDATE if exists

April 13, 2022April 13, 2022 Team Fedingo Leave a comment MySQL
mysql insert or update if exists

Sometimes you may need to insert or update data in MySQL table. Here are the steps to use MySQL Insert or Update.

Continue reading


How to Do Regular Expression Replace in MySQL

April 13, 2022April 13, 2022 Team Fedingo Leave a comment MySQL
mysql regular expression replace

Sometimes you may need to replace multiple strings & patterns in column in MySQL. Here is how to do regular expression replace in MySQL.

Continue reading


How to Get Digits from String in MySQL

April 13, 2022April 13, 2022 Team Fedingo Leave a comment MySQL
mysql extract number from string

Sometimes you may need to extract number from string or numerical value from string in MySQL. Here is how to get digits from string in MySQL.

Continue reading


How to Update Row Based on Previous Row in MySQL

April 1, 2022April 1, 2022 Team Fedingo Leave a comment MySQL
update columns based on previous row

Sometimes you may need to update row based on previous row in MySQL. Here are the steps to do it.

Continue reading


How to Unlock User Account in MySQL

March 30, 2022March 30, 2022 Team Fedingo Leave a comment MySQL
unlock user account in mysql

Sometimes you may need to unlock user account in MySQL. Here are the steps to do it.

Continue reading


How to Lock User Account in MySQL

March 30, 2022March 30, 2022 Team Fedingo Leave a comment MySQL
lock mysql user account

Sometimes you may need to lock user account in MySQL. Here are the steps to lock user accounts in MySQL.

Continue reading


How to Take Backup of MySQL Database in Python

March 14, 2022March 14, 2022 Team Fedingo Leave a comment Django, MySQL, Python
mysql backup python

Sometimes you may need to take backup of MySQL database in Python. Here are the steps to do it.

Continue reading


MySQL Clustered Index

February 28, 2022February 28, 2022 Team Fedingo Leave a comment MySQL
mysql clustered index

Clustered Indexes allow faster lookups and improve query performance. Here are more details about clustered indexes in MySQL.

Continue reading


MySQL AND Operator With Examples

February 28, 2022February 28, 2022 Team Fedingo Leave a comment MySQL
mysql and operator

MySQL AND operator is useful to combine variables, conditions and column values in MySQL. Here are different MySQL AND operator examples.

Continue reading


How to Change Default MySQL Data Directory

February 18, 2022February 18, 2022 Team Fedingo Leave a comment MySQL
change mysql data directory

Sometimes you may need to change default MySQL data directory. Here are the steps to do it.

Continue reading


Posts navigation

Older posts

Recent Posts

  • How to Convert PDF to Text in Python
  • How to Convert Text to CSV File in Python
  • How to Split List Into Even Chunks
  • How to Split File in Python
  • How to Show File Without Comments in Linux

Follow Us

  • Facebook
  • Twitter
© 2021 Fedingo | About Us | Contact Us | Privacy Policy
dazzling Theme by Colorlib Powered by WordPress