Category: Tutorials

How to Upgrade Ubuntu 19.04 to 19.10

As you would know already, that there will be 2 ubuntu releases every year and every first even release of the year will be LTS (Long Term Support) release. Now let’s see how to Upgrade Ubuntu 19.04 to 19.10 or how to update ubuntu 19.04 to 19.10. Things to Note before you start the procedure

Find all tables with column name in SQL

If you have wondered how can you get all the table names which contain a specific column, here is a simple SQL query to find all tables with column name in SQL. Find all tables with column name select column_name, table_name from information_schema.columns where column_name like "%mycolumname%"; or select column_name, table_name from information_schema.columns where column_name

Bit Depth Vs. Bit Rate

Bit depth and Bit rate, you might think that these two similar. They are however, two completely different. Bit rate describes the speed that sound data is played back. For example : A 120 Kbps MP3 song will process at 120, 000 bits per second A 320 Kbps MP3 song will process at 320, 000