Apps Media

Starting a Remote Session from one Ubuntu machine on another Ubuntu machine In this article, we look at ways to start a remote session from one Ubuntu machine on another. First to clarify, starting a remote session is not the same as Desktop sharing with tools like VNC. What I really wanted was to let the remote machine operate using display settings of my client machine. Reason was, on my primary machines at my home, I have a dual display with 23 and 24 inch monitors, one of which is rotated by 90 degrees. Trying to access this over VNC meant that my local view consisted of this extended desktop made up of display real estate that was impossible to manipulate over my client machine that was a laptop. This requires two steps Step 1: Connect to the machine using secure shell Step 2: Launch a remote gnome session Here are the steps. Step 1: Connect to the machine using a secure shell The first step was to open a terminal windows and start a sescure shell session. $ ssh -X user @host_mach...

SQL Query in another SQL Query SQL Subquery You might have wanted to do a SQL  query inside an another SQL  query. You can do this using SQL Subquery . Its simple as ABC . Heres an example : SELECT * FROM `fdposts` WHERE user IN (SELECT friend FROM `fdfriends` WHERE user=subins2000) The above code will select rows in table  fdposts  where user is the value of friend row in the table fdfriends . As you can see its very simple. Heres another example : SELECT * FROM `posts` WHERE user IN (SELECT name FROM `members` WHERE user=subins2000) The above code will select rows in table  posts where user is the value of the row name  in the table members . Enjoy !!! download  file  now