https://www.tesla.com/ko_kr/referral/namha214845 NAMHA 님의 추천을 통해 Tesla 제품 주문하기NAMHA님이 ₩660,000의 Tesla 신차 할인 혜택을 선물했습니다 인벤토리 살펴보기www.tesla.com https://www.tesla.com/ko_kr/referral/namha214845 NAMHA 님의 추천을 통해 Tesla 제품 주문하기NAMHA님이 ₩660,000의 Tesla 신차 할인 혜택을 선물했습니다 인벤토리 살펴보기www.tesla.com https://www.tesla.com/ko_kr/referral/namha214845
create table t (n int); insert into t values (1); -- 13번 반복하면 4096행이 생성됨 insert into t select * from t SELECT * FROM t SELECT * FROM date_t create table date_t (d date, ds char(10)); insert into date_t select d, date_format(d, '%Y-%m-%d') from ( select @rnum:=@rnum+1 as rownum, date(adddate('2024-01-01', interval @rnum day)) as d from (select @rnum:=-1) r, t ) t where year(d) [출처] http:/..
# YYYY-MM-DDselect * from (select adddate('1970-01-01',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) selected_date from (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 ..
WITH nums ( num ) AS ( SELECT ROW_NUMBER() OVER ( ORDER BY ( SELECT NULL ) ) -1 FROM sys.all_columns ) , dlist ( aDay ) AS ( SELECT TOP 500 DATEADD( DAY, num * -1, '2024-05-01' ) FROM nums ) , dlist2 ( aDay, TGD ) AS ( SELECT aDay, DATEADD( DAY, ( ( 8 - DATEPART( WEEKDAY, aDay ) ) % 7 ) - 3, aDay ) AS ThuOfGivenDay FROM dlist ) SELECT * , DATEPART( YEAR, TGD ) AS [년] , DATEPART( MONTH, TGD ) AS ..
- Total
- Today
- Yesterday
- Shell
- 자동차
- Windows
- tomcat
- Oracle
- MySQL
- Linux
- 백업
- 윈도우
- user
- 파일
- mssql
- 데이터
- 테이블
- java
- apache
- 오라클
- table
- eclipse
- DB
- sql
- delete
- Toad
- server
- select
- 서버
- DATABASE
- 리눅스
- IP
- 설정
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | |||||
3 | 4 | 5 | 6 | 7 | 8 | 9 |
10 | 11 | 12 | 13 | 14 | 15 | 16 |
17 | 18 | 19 | 20 | 21 | 22 | 23 |
24 | 25 | 26 | 27 | 28 | 29 | 30 |