How to easily copy table rows using only SQL queries

To easily copy table rows using only queries, you need to create temporary table, copy rows to this table from from table where you want to copy rows, optionally change some values and put them back to table where you want to have copied rows.

How to do this using queries

Continue reading How to easily copy table rows using only SQL queries

The most resource hungry processes on Linux

The command with which we will see a list of processes that consume the most RAM (resources).

Instead of 10 you can specify any number of processes displayed.

To kill any process write:

Continue reading The most resource hungry processes on Linux