show tables like in mysql

SHOW TABLES WHERE Tables_in_mydbname LIKE '%reward%'

suppose mydbname is 'blogposts'

SHOW TABLES WHERE Tables_in_blogposts LIKE '%reward%'

Firefox ignores option selected=“selected”, Selected = '"

This behaviour is hard coded in FF.

Add autocomplete="off" HTML attribute to the respective select tag.

git commit get fatal error “fatal: CRLF would be replaced by LF in”

The usual fix is to convert those files yourself, with dos2unix or Swiss File Knife.
I have always preferred to keep core.autocrlf to false, which means:
git config --global core.autocrlf false

How to enter Control + alt + delete in vitual box from mac

On an OS X host, try
  • control+alt/option+fn+delete or
  • cmd+fn+delete
I used the onscreen keyboard in Windows 7 which showed the guest OS receiving ctrl and alt/option, but not delete. By adding the fn key to the combination, it seems the Mac's idea of "delete" (normally like Windows' "backspace") becomes Windows' "delete".

Install Node.js with Ubuntu Package Manager

To install Node.js, type the following command in your terminal:
Then install the Node package manager, npm:
Create a symbolic link for node, as many Node.js tools use this name to execute.
Now we should have both the Node and npm commands working:


If you are getting this error then you probably reset the permissions on your hidden .ssh directory in your user folder, and your keys aren’t going to work anymore. It’s very important that these files not be writable by just anybody with a login to the box, so openssh will give you an error if you try to use them.
The full error message:
Permissions 0744 for '/home/geek/.ssh/id_rsa' are too open.
It is recommended that your private key files are NOT accessible by others.
This private key will be ignored.
bad permissions: ignore key: /home/geek/.ssh/id_rsa
To fix this, you’ll need to reset the permissions back to default:
sudo chmod 600 ~/.ssh/id_rsa
sudo chmod 600 ~/.ssh/
If you are getting another error:
Are you sure you want to continue connecting (yes/no)? yes
Failed to add the host to the list of known hosts (/home/geek/.ssh/known_hosts).
This means that the permissions on that file are also set incorrectly, and can be adjusted with this:
sudo chmod 644 ~/.ssh/known_hosts
Finally, you may need to adjust the directory permissions as well:
sudo chmod 755 ~/.ssh
This should get you back up and running.

Get attribute of SPAN using JavaScript

<span id='abc' email=''> xyz </span>

How to get attribute of SPAN using JavaScript


How to SPAN content or html or text using JavaScript