MySQL query to get column names

SELECT `COLUMN_NAME` 
FROM `INFORMATION_SCHEMA`.`COLUMNS` 
WHERE `TABLE_SCHEMA`='yourdatabasename' 
    AND `TABLE_NAME`='yourtablename';

Applications Don't Show Up in Spotlight

1. Go to System Preferences, Select Spotlight
2. Go to the Privacy tab in the Spotlight system preferences
3. Click the "+" button
4. Press Shift-Command-C to reveal your hard drives (if they are not available otherwise), or simply navigate to your hard drive (most likely MacintoshHD)
5. If you have more than one hard drive, hold the Command key and click your various drives to add them to your selection
6. Click the “Choose” button to add them to the Privacy list
7. Ignore the warning.
8. Remove the hard drive by clicking the "-" sign.
9. Have a nice day :)

Manual restart Philips Android Smart TV

Press Settings button 
Select All settings -> Android Settings
Press OK
Select Device -> About -> Restart
Press OK

Ubuntu 16.04 : Configure WOL

• Set in /etc/default/tlp

WOL_DISABLE=N 

• Set in /etc/default/halt

NETDOWN=no 



• execute

sudo ethtool -s eth0 wol g

• check

sudo ethtool eth0

Settings for eth0:

         ...
  Supports Wake-on: g
  Wake-on: g
  Link detected: yes

serial console

Create /etc/init/ttyS0.conf

start on stopped rc RUNLEVEL=[12345]
stop on runlevel [!12345]

respawn
exec /sbin/getty -L 115200 ttyS0 vt102

Start:

sudo start ttyS0

FROM