Isa Subani

  UPDATE tableA a,  tableB b,  SET a.email = b.email, a.name = b.name WHERE a.id = b.id tableB ini boleh pakai subquery seperti ini (SELECT b.id, b.email, b.name FROM tableXXX)

  1. Database -> Add -> Connected 2. Persistent -> right click persistent -> Generate Persistent Mapping -> By Database Schema 3. Choose connection yang tadi dibuat, masukan package yang dituju pilih table lalu oke. secara otomatis akan dibuat kan persistent model class nya tanpa perlu buat manual

  Requirement: - maven - jdk 8 - intelliJ  How To:  nambahin dependency ini untuk membaca file csv di pom.xml <?xml version="1.0" encoding="UTF-8"?> <project xmlns= "http://maven.apache.org/POM/4.0.0" xmlns:xsi= "http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation= "http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd" > <modelVersion> 4.0.0 </modelVersion> <parent> <groupId> org.springframework.boot </groupId> <artifactId> spring-boot-starter-parent </artifactId> <version> 2.4.4 </version> <relativePath/> <!-- lookup parent from repository --> </parent> <groupId> com.fluex404 </groupId> <artifactId> springboot-upload-read-csv </artifactId> <version> 0.0.1-SNAPSHOT </version> <name> springboot-upload-file-read-csv </name> ...

  1- Comment out   bind 127.0.0.1 2- Change  protected-mode  to  no 3- Protect my server with  iptables  ( https://www.digitalocean.com/community/tutorials/how-to-implement-a-basic-firewall-template-with-iptables-on-ubuntu-14-04 ) source:  https://stackoverflow.com/questions/19091087/open-redis-port-for-remote-connections