Tech tutorials, How To's & User guides

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

MySQL

How to Check if Column is Empty or Null in MySQL

December 13, 2022June 13, 2024 Sreeram Sreenivasan Leave a comment MySQL
check if column is empty or null in mysql

Sometimes you may need to check if column is empty or null in MySQL. Here are 3 different ways to check for null values in column.

Continue reading


How to Remove Leading & Trailing Whitespace from Column in MySQL

November 15, 2022November 15, 2022 Sreeram Sreenivasan Leave a comment MySQL
mysql trim leading trailing whitespace

Often you may need to remove leading & trailing whitespace from strings in MySQL. Here are the steps to do it.

Continue reading


How to Set Initial Value & Auto Increment in MySQL

August 23, 2022August 23, 2022 Sreeram Sreenivasan Leave a comment MySQL
set initial value and auto increment in mysql

Sometimes you may need to set initial value and auto increment in MySQL. Here are the steps to do it.

Continue reading


How to Copy Column to Another Column in MySQL

June 30, 2022July 23, 2025 Sreeram Sreenivasan Leave a comment MySQL
copy column to another column in mysql

Sometimes you may need to copy column to another column in MySQL. Here are the steps to do it.

Continue reading


MySQL AND Operator With Examples

February 28, 2022February 28, 2022 Sreeram Sreenivasan 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 Run MySQL Query from Command Line

February 18, 2022February 18, 2022 Sreeram Sreenivasan Leave a comment CentOS/RHEL, Linux, MySQL, Ubuntu
run mysql queries from command line

Sometimes you may need to run MySQL queries from terminal or shell script. Here is how to run MySQL query from command line.

Continue reading


How to Extract Database from MySQL dump file

February 17, 2022February 17, 2022 Sreeram Sreenivasan Leave a comment MySQL
extract database mysql dump file

Sometimes you may need to extract database from MySQL dump file. Here are the steps to restore or import single database in MySQL.

Continue reading


Python Script to Load Data in MySQL

January 21, 2022July 23, 2025 Sreeram Sreenivasan Leave a comment MySQL, Python
python script to load csv into mysql

Python allows you to load data into databases and run SQL queries. Here is the python script to load data in MySQL.

Continue reading


How to Repair MySQL Databases & Tables

November 29, 2021November 29, 2021 Sreeram Sreenivasan Leave a comment MySQL
repair mysql database

Sometimes you may need to repair MySQL databases & tables as they grow. Here is how to repair MySQL databases & tables.

Continue reading


How to Optimize MySQL Tables

November 29, 2021November 29, 2021 Sreeram Sreenivasan Leave a comment MySQL
optimize mysql table

Sometimes you may need to optimize MySQL tables to improve query speed and performance. Here is how to optimize MySQL tables.

Continue reading


Posts navigation

Older posts

Recent Posts

  • How to Start Background Process in Python
  • How to Check if Substring is in List of Strings
  • How to Check if Column is Empty or Null in MySQL
  • How to Schedule Multiple Cron Jobs in One Crontab
  • How to POST JSON Data in Python Requests

Follow Us

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