Date_Column_Update.sql

ALTER TABLE LAMINATOR ADD (LAM_DATE_2 DATE);
-- Update the column value in LAM_DATE
UPDATE LAMINATOR SET LAM_DATE = REPLACE(LAM_DATE, '/', '-') WHERE 1;
-- Convert the data type to date data type in the new column
UPDATE LAMINATOR SET LAM_DATE_2=STR_TO_DATE(LAM_DATE, '%m-%d-%Y');
-- DROP the old column
ALTER TABLE LAMINATOR DROP LAM_DATE;
-- rename the column name back
ALTER TABLE `LAMINATOR` CHANGE `LAM_DATE_2` `LAM_DATE` DATE NULL DEFAULT NULL;







ALTER TABLE FILM ADD (DATE_2 DATE);
-- Update the column value in LAM_DATE
UPDATE FILM SET DATE = REPLACE(DATE, '/', '-') WHERE 1;
-- Convert the data type to date data type in the new column
UPDATE FILM SET DATE_2=STR_TO_DATE(DATE, '%m-%d-%Y');
-- DROP the old column
ALTER TABLE FILM DROP DATE;
-- rename the column name back
ALTER TABLE `FILM` CHANGE `DATE_2` `DATE` DATE NULL DEFAULT NULL;







ALTER TABLE blend ADD (DATE_2 DATE);
-- Update the column value in LAM_DATE
UPDATE blend SET DATE = REPLACE(DATE, '/', '-') WHERE 1;
-- Convert the data type to date data type in the new column
UPDATE blend SET DATE_2=STR_TO_DATE(DATE, '%m-%d-%Y');
-- DROP the old column
ALTER TABLE blend DROP DATE;
-- rename the column name back
ALTER TABLE `blend` CHANGE `DATE_2` `DATE` DATE NULL DEFAULT NULL;



UPDATE `LAM_CHART_DATA` SET `THICKNESS`= IF(`BATCH_NUM` LIKE '%-150-%', 150, 90);

SELECT INSERT('Cats and dogs', 6, 3, 'like');

UPDATE `RESISTANCE` SET `LOT_DATE`= INSERT(`LOT_DATE`, 8, 0, '-')