sql change column name based on value

ALTER TABLE "table_name" RENAME COLUMN "column 1" TO "column 2";

4
1
Phoenix Logan 186120 points

                                    ALTER TABLE `table_name` 
CHANGE `old_name` `new_name` VARCHAR(10) 
CHARACTER SET utf8 
COLLATE utf8_general_ci NULL 
DEFAULT NULL;

4 (1 Votes)
0
3
1
Rubixphys12 15320 points

                                    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;

3 (1 Votes)
0
Are there any code examples left?
Create a Free Account
Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.
Sign up
Develop soft skills on BrainApps
Complete the IQ Test
Relative searches
dynamically rename column names sql update a column depending on the column name in sql server how to rename table name in sql change the name of an existing table in sql alter query to change column name changing name of column sql change column NAME to a table how to rename column name in sql server changing table name in sql rename sql collum update column name in sql server alter table modify name column how to change sql column name change col name in sql how to update column name in sql rename column in sql sql change name of value renamecolumn in sql rename table column name in sql how to change column name dynamically in sql how to change name in sql tbale alter table rename column sql table name chnage sql change column name in ms sql sql change name of column in select query alter table change name colum change column name select sql sql change table column name change the table name in sql how to change row name in sql update a column value name in sql update a column data name in sql alter table name in sql sql query to change a column name how to update name of a column sql rename column name in sql select statement change column name of a table in sql server update table name in sql sql change column name based on value how to CHANGE TABLE NAME sql rename table name in sql rename column name sql sql change name of table how to rename column name in sql server using query change column name in query sql alter table change column name sql server update column name table sql server how to update a column name in sql alter table in sql update column name sql select change column name how to modify a name in sql change a column name in sql sql server alter column name rename a column in sql sql rename column ms sql rename column change field name sql alter table column name updating coluymn name in sql server possible to change a table name in SQL hpw to chaneg column name in sql rename sql column how to change query name sql sql table change name sql query to change table name in sql rename a clumn in sql how to rename a column in sql sql RENAME A COLUMN change column name sql server sql select change name of column rename the table name in sql sql change colum name how to rename column name in sql modify column name in sql server how to change the names of columns in sql sql alter modify column name change clolum name in sql how to rename a column in sql server sql edit column name changing the name of a column in sql ho to change a column name in sql alter table update name column sql rename column name in sql how to rename result coloum name in sql how to change column name in sql server sql server alter table change column name select a colum but rename it sql change name of table in sql sql change value into name sql update with column name rename column in sql server how to change the table name in sql how to change name incolumn in sql how to change existing column name in sql server how to change column name in a table sql server rename column how to change name of variable in sql alter table sql change table name how to update table name in sql changing column name in sql change the name of column in sql how to change sql table name sql alter column name sql column name change sql rename field in query sql command to change column name sql server column name change alter table rename column sql server select sql change column name sql rename column containing data how to change column name in sql using query modify table name sql changing name of variable sql SQL RENAME COLUMN how to change name of a column in sql SQL change name of field how to change column name in sql changing the name of a table in sql sql change name of column in select can we change table name in sql change colum name in table sql can we rename a column in the output of sql query sql modify column name renaming column in sql change column name sql change column name in sql select statement rename column sql how to change the name of a table in sql sql change column name dynamically t-sql alter column name sql query to change table name sql change colun name change column name in sql server column rename in sql server change table name sql sql alter colmn name alter column name in sql how to alter column name in sql edit col name sql how to change the name of table in sql change name collumn sql update name of column sql sql server how to change name of sql table sql change table name sql how to change column name how to change the column name in sql changing column names in sql query results change table column name alter table change name sql rename column name in sql server update column name sql sql replace with column name change colum name in sql how to rename table column name in sql change name of column name sql sql rename an if column change column name in select query sql server change column name in sql server using select query sql table change column name query to rename a column in sql sql query to change column name change table name in sql sql server replace column name query change column name how to change column name in sql select statement how to change table name in sql SQL HOW TO UPDATE COLUMN NAME sql change column name chnage column name sql how to rename fields in sql update column name in sql modify column name in sql change the field name in sql change name of sql table alter table & rename table column how to change a collumn name in sql sql statement change column name change name on column sql changing column name in sql server save sql table column name change sql change a coloumn name can we change the name of the column using alter sql change a column name dsql in column rename reanem column in sql RENAME ALL COLUMNS IN DB SQL SERVER rename of column in sql renaming a column in sql modify table column name in sql which command to do wee use in SQL to rename a column modifie column name in sql rename sql alter table with name - change table column name in sql sql update column name change name of attribute sql modifying column name in sql how to change the name of column in sql alter column name change name of a column in sql sql alter table rename column how to edit table headers in sql sql change col name how to change the column name of a table in sql update column name in sql table query to modify column name in sql rename COlumn how to rename column in sql rename column name in sql table how to rename a column from a table in sql change name of column in tsql change name of column in sql how to rename a column sql can we change column name in sql sql rename columns changing cxolumn name sql renaming a column in sql alter table sql renam eoclumn dql alter change column anme mysql rename colum name how to rename field name in sql alter the column name in sql change the column name in sql alter table rename column how to change name of coloumn in sql change column name syntax in sql change name of a column sql sql command to rename column name alter table name sql alter table change column name change column name in sql change name of colum in sql table
Made with love
This website uses cookies to make IQCode work for you. By using this site, you agree to our cookie policy

Welcome Back!

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign in
Recover lost password
Or log in with

Create a Free Account

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign up
Or sign up with
By signing up, you agree to the Terms and Conditions and Privacy Policy. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.
Creating a new code example
Code snippet title
Source