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.
You can capture a Screenshot of your entire screen or just a selected portion of it. The screenshot is automatically saved to your desktop.
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:
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
};