Search
 
SCRIPT & CODE EXAMPLE
 

SQL

update one column from another column in same table

select * from stuff

update stuff
set TYPE1 = TYPE2
where TYPE1 is null;

update stuff
set TYPE1 = TYPE2
where TYPE1 ='Blank';

select * from stuff
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql json query 
Sql :: brew start postgres 
Sql :: mysql decimal allow negative values? 
Sql :: change data type postgresql 
Sql :: sql server insert into table 
Sql :: sql update insert and delete 
Sql :: mysql grant all on all databases 
Sql :: oracle apex debug time 
Sql :: sql get inserted primary key 
Sql :: mysql timestamp format 
Sql :: soql last week 
Sql :: drop a view in sqlite 
Sql :: insert array postgresql 
Sql :: sql select where in 
Sql :: how to drop database name in postgresql 
Sql :: select distinct postgres 
Sql :: select top 3 sql 
Sql :: alternative for LIMIT sql 
Sql :: 11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 
Sql :: export mysql db using command line 
Sql :: query to find object dependencies in oracle 
Sql :: view table mysql 
Sql :: sum value by month sql 
Sql :: INITCAP in Oracle example 
Sql :: mysql loop 
Sql :: mysqldump database 
Sql :: how to run sql server on mac 
Sql :: how to get previous year from sysdate in oracle 
Sql :: import mysql dump database command line linux 
Sql :: array of objects sql 
ADD CONTENT
Topic
Content
Source link
Name
6+5 =