Categories
Linux MySql Open Source Solutions

How to Rename Column in Mysql

Modifying database schemas is a routine task, but the exact syntax to alter structural properties varies heavily across database versions. If you are trying to rename a column in MySQL, using the wrong command can lead to syntax errors or accidental data loss. How you rename a column depends entirely on whether your environment runs […]

Categories
Laptop OsX

How To Take A ScreenShot on Mac

You can capture a Screenshot of your entire screen or just a selected portion of it. The screenshot is automatically saved to your desktop. How to take a screenshot of your entire screen Press Shift+Command (⌘)+3. The screenshot will be saved as a .png file on your desktop How to take a screenshot of a […]

Categories
Android Apps Device Nexus 5

Error 70 Gapps install – Fixed

If you are encountering the following error while trying to flash Gapps with your custom rom: Error 70: Insufficient storage space available in System partition. Here is the simple fix for the problem: Flash a smaller size version of the Gapps ROM via TWRP.  Pick either Pico/Micro versions of the ram. For Nexus 5 and […]

Categories
JavaScript Open Source Solutions Web

JavaScript Date Format YYYY-MM-DD

Here is a simple function that takes the input of JS Date and returns a string of format YYYY-MM-DD: var getDateFromDateTime = function(date) { date = new Date(date); //Using this we can convert any date format to JS Date var mm = date.getMonth() + 1; // getMonth() is zero-based var dd = date.getDate(); if(mm