Tag: Help

Categories
Laptop OsX Solutions

Open Apps From Unidentified Developers in Mac OS Sierra

Here is How to open applications that can’t be opened as they are from an ‘unidentified developer’ in Mac OS Sierra

How to Open Applications From Unidentified Developers in Mac OS Sierra

Opening a Specific App:

If you would like to allow just one specific application to run, use the following steps:

  1. Hold down the Control key and click the application icon.
  2. A contextual menu should appear – here Choose ‘Open’.
  3. A popup will appear asking you to confirm this action – Click the Open button.

Once you open the App is opened its stored as an exception in the settings and you can open it in future directly by double clicking it.

Allowing all Apps to Open(Works with some versions of Sierra):

If you would like to allow all applications from unidentified developers to run, use the following steps:

  1. Click on the “Apple” menu on the top left of your screen
  2. Select “System Preferences” option from the menu
  3. Choose ‘Security & Privacy’ from the System Preferences menu.
  4. Select ‘General’ from the tabs at the top of the Security & Privacy page.
  5. Click the ‘Lock icon’ at the bottom left of the window.
  6. Enter your administrative username and password and click Unlock
  7. Select ‘Anywhere’ from list of places to allow downloaded applications from. If this option does not show up in the window then you will have use the first method with each app.
  8. A popup window will appear asking you to confirm your selection. Click the Allow From Anywhere button.
Categories
Linux MySql Open Source Solutions

How to Rename Column in Mysql

rename column mysql

To Rename a Column in Mysql we need to use the ALTER query with CHANGE COLUMN statement. The standard version of this query is:

ALTER [ONLINE | OFFLINE] [IGNORE] TABLE tbl_name
CHANGE [COLUMN] old_col_name new_col_name column_definition
[FIRST|AFTER col_name]

For Example:

ALTER TABLE City CHANGE CityId cityId varchar(25) NOT NULL;

Note: You will need to mention every constraint of the original column as defaults are assumed otherwise.

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<10){ mm="0"+mm; } if(dd<10){ dd="0"+dd; } return [date.getFullYear(), mm, dd].join('-'); // padding };

Categories
JavaScript Open Source Solutions Web

Convert JavaScript Date format YYYYMMDD

JQuery Check If Element Exists

Here is a simple function that takes the input of JS Date and returns a string of format YYYYMMDD:

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<10){ mm="0"+mm; } if(dd<10){ dd="0"+dd; } return [date.getFullYear(), mm, dd].join(''); // padding };

Categories
Open Source Solutions

Git – Undo Uncommitted Changes to a Specific File

Here are the steps remove uncommited changes to a file in Git:

  • Firstly check the list of uncommited changes in your system by using the command “git status“
  • To remove the changes to the file use the command: git checkout <filepath>  Make sure you use the full path as seen in the git status output
  • Execute “git status” again to make sure that the file is now clean again.