change value of one column in sql code example

Example 1: sql change column types

ALTER TABLE table_name
ALTER COLUMN column_name datatype;

-- Example
ALTER TABLE product
ALTER COLUMN description VARCHAR(250);

Example 2: set value based on column

df.loc[df['c1'] == 'Value', 'c2'] = 10

Example 3: how to update row in sql

UPDATING ROW
Update TableName set ColumnName = value where condition;
update scrumteam set firstname =‘Martin' where EmployeeID='1';
update scrumteam set lastname =‘Murtin' where firstname='Tom’;

Tags:

Related