Learn how to cast an integer to a string in PostgreSQL. >>>
Monthly Archives: March 2025
How to Back up a Single Table With Its Data From a Database
Learn how to back up an SQL table and its data. >>>
Making a Column Nullable in SQL
Learn how to make a column nullable in SQL across PostgreSQL, SQL Server, and MySQL. >>>
How to Execute Multiple Queries Using psql Command From Bash
Learn how to use the psql command from the Bash command line to execute multiple SQL queries at once. >>>
Getting the Size of a Table in MySQL
MySQL supports different types of storage engines and these can take differing amounts of disk space to use when storing tables. Whether it is MyISAM or InnoDB, we can query MySQL to find out how much space each of our tables is taking up to better help us do capacity planning. >>>