use newdb;
select * from superstore;
alter table superstore ADD CurrDateTime VARCHAR(20);
alter table superstore MODIFY CurrDateTime DATETIME;
alter table superstore DROP tempColumn;
update superstore SET CurrDateTime=NOW();
update superstore SET CurrDateTime=NULL;
update superstore SET CurrDateTime=NOW() where Category in("Furniture", "Technology");