본문 바로가기
  • AI (Artificial Intelligence)
Skills/Database

Select Insert Example

by 로샤스 2017. 12. 21.

INSERT INTO llx_user_rights (rowid, entity, fk_user, fk_id)

select rowid+30000 as rowid, entity, 16 as fk_user, fk_id from llx_user_rights

where fk_user = 13

and fk_id not in (select fk_id from llx_user_rights where fk_user = 16)



UPDATE mp_timesheet AS U1, mp_timesheet AS U2 

SET U1.timesheet_date = DATE(U2.timesheet_in)

WHERE U1.timesheet_id = U2.timesheet_id




'Skills > Database' 카테고리의 다른 글

뷰 (View) 의 개념 & 특징  (0) 2019.10.30
Installing MongoDB on a Mac  (0) 2019.08.09
[MySQL] 8.1.1 Obtaining Auto-Increment Values  (0) 2017.07.21
mac을 위핸 sql tool  (0) 2015.10.26
mysql 무료 툴 간단 벤치마킹  (0) 2015.10.26

댓글