sql change column name based on value
ALTER TABLE "table_name" RENAME COLUMN "column 1" TO "column 2";
4
1
ALTER TABLE `table_name`
CHANGE `old_name` `new_name` VARCHAR(10)
CHARACTER SET utf8
COLLATE utf8_general_ci NULL
DEFAULT NULL;
Thank you!
1
0
3
1
SELECT CASE lower(col1)
WHEN 'agree' THEN 'Ok'
ELSE
CASE
WHEN col2 = 1 THEN 'Ko'
ELSE 'Maybe'
END
END AS my_result
FROM table_name;
Thank you!
1
0
Are there any code examples left?
New code examples in category SQL