Important code – MySQL

-- load big file

LOAD DATA INFILE '$path_file' 
INTO TABLE table_name
FIELDS TERMINATED BY '$delimiter' OPTIONALLY ENCLOSED BY '$ENCLOSED' LINES TERMINATED BY '\n' IGNORE 1 ROWS
(@var1,@var2,column_name3,column_name4)
            
set column_name1=@var1, column_name2=@var2

-- insert into from query

INSERT INTO `table_name1` ( column_name1, column_name2)
(SELECT column_name1, column_name2 FROM `table_name2`)

UPDATE  tabel_a dp, 
(    
  select col_a,col_b from tabel_b
) dp_t
            
SET dp.col_a=dp_t.col_a, dp.col_b=dp_t.col_b
WHERE id=1

-- if condition

if(column_name<>'',1,0) var,

ifnull(column_name,0) var,

-- case when condition

(case 
  when column_name1 > 0 then 1 
  when column_name2 > 1 then 2
  else 0 
  end
) as var1,

-- number 2 digit
LPAD(column_name, 2, '0')

-- show 2 angka dibelakang koma
FORMAT(column_name,2)

INSERT into table_name (col_1,col_2) 
( 
    select sf,hp_sf from (select sf,hp_sf from table_name_1 where sf<>'' GROUP BY sf)  core
)
            
ON DUPLICATE KEY UPDATE hp=core.hp_sf