Let's Make Things Better

WP Delete ALL comments

Delete all pending comments: DELETE from wp_comments WHERE comment_approved = ‘0’ Delete all approved comments: DELETE from wp_comments WHERE comment_approved = ‘1’ Delete all trash comments: DELETE from wp_comments WHERE comment_approved = ‘trash’ Delete all spam comments: DELETE from wp_comments WHERE comment_approved = ‘spam’

How to convert .VHDX to .VDI VirtualBox file

Linux: vboxmanage clonemedium disk /full/path/to/inputdisk/vmdisk.vhdx /full/path/to/outputdisk/vmdisk.vdi –format VDI Windows: c:\ > “C:\Program Files\Oracle\VirtualBox\VBoxManage” clonemedium disk /full/path/to/inputdisk/vmdisk.vhdx /full/path/to/outputdisk/vmdisk.vdi –format VDI

How to Create and Use Alias Command in Linux

List Currently Defined Aliases in Linux $ alias As you can see, executing. $ ll Is equivalent to running: $ ls -alF Creating Temporary Aliases $ alias shortName=”your custom command here” $ alias wr=”cd /var/www/html” Creating Permanent Aliases $ nano ~/.bashrc #My custom aliases alias home=”ssh -i ~/.ssh/mykep.pem tecmint@192.168.0.100” alias ll=”ls -alF” Remove an alias …

How to Hide Quick Access on Google Drive

1. Go to drive.google.com from your desktop browser. 2. Click on Settings Icon from top-right side. Then click Settings. 3. A Settings Pop-up will come up. Look for the Quick Access section that says “Make relevant files handy when you need them.” 4. Uncheck this option. 5. Click Done from top-right corner and refresh your browser to see changes. It should be gone.

Print Size of Fundamental Types

#include <iostream> using namespace std; int main() { cout << “sizeof(char) is ” << sizeof(char) << ” bytes ” << endl; cout << “sizeof(short) is ” << sizeof(short) << ” bytes ” << endl; cout << “sizeof(int) is ” << sizeof(int) << ” bytes ” << endl; cout << “sizeof(long) is ” << sizeof(long) << …