MySQL에서 특정날짜 사이의 날짜 목록 모두 가져오기

1
2
3
4
5
6
7
8
9
select * from 
(select adddate('2010-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 union select 8 union select 9) t1,
 (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) t2,
 (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) t3,
 (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) t4) v
where selected_date 
between '2018-09-10' and '2018-10-31'
cs

 

 

참고 : stackoverflow.com/questions/9295616/how-to-get-list-of-dates-between-two-dates-in-mysql-select-query

 

How to get list of dates between two dates in mysql select query

I want list of dates lies between two dates by select query. For example: If i give '2012-02-10' and '2012-02-15' I need the result. date ---------- 2012-02-10 2012-02-11 2012-02-12 2012-0...

stackoverflow.com

 

 

Posted by 셋부터넷
,

Eclipse사용 중 특정 프로젝트의 pom.xml에서 첫문단 <?xml version="1.0" encoding="UTF-8"?> 오류발생 시 아래와 같이 처리

 

1. m2e 커넥터 설치

참고 : download.eclipse.org/m2e-wtp/releases/1.4/

 

Eclipse software repository | The Eclipse Foundation

The Eclipse Foundation - home to a global community, the Eclipse IDE, Jakarta EE and over 360 open source projects, including runtimes, tools and frameworks.

download.eclipse.org

또는

2. maven-jar-plugin 다운그레이드

1
2
3
4
<properties>
    <!-- ... -->
    <maven-jar-plugin.version>3.1.1</maven-jar-plugin.version>
</properties>
cs

pom.xml에 추가

참고 : stackoverflow.com/questions/56455851/maven-pom-xml-problem-unknown-error-at-top-line-xml-version-1-0-encoding

 

Maven POM.xml problem - Unknown error at top line ( )

I am setting up a project in STS with Spring starter project and added required dependencies like spring security and JSP. But the top line of pom file throwing an error as Unknown Can anybody he...

stackoverflow.com

 

 

 

Posted by 셋부터넷
,

sing Git and the Eclipse IDE, you have a series of commits in your branch history, but need to back up to an earlier version. The Git Reset feature is a powerful tool with just a whiff of danger, and is accessible with just a couple clicks in Eclipse.

In Eclipse, switch to the History view. In my example it shows a series of 3 changes, 3 separate committed versions of the Person file. After commit 6d5ef3e, the HEAD (shown), Index, and Working Directory all have the same version, Person 3.0.

 

 

Right-click on any of the commits to show the context menu, and select Reset to show a sub-menu with 3 options: Soft, Mixed and Hard. These options affect which of git's 3 sets of files are Reset.

 

 

Before proceeding, a brief reminder that Git has 3 different sets of the files.

First is the HEAD, which is everything that is safely committed into the Git repository.

 

Second is the Index, which are the files as they will look in the HEAD once you do the next commit - in Eclipse, the Git Staging view's “Staging Area” shows the files ready but not yet committed.

 

Third is the Working Directory. Think of this as the Sandbox in which you can work and actually make changes (the HEAD and Index are not editable files in the same way, they are stored in Git’s internal representation, not directly accessible for editing purposes).

 

The different shades of Reset affect one, two or all three of these sets.

So, in the History view above, everything is updated to version 3 of the Person file. How can we use Eclipse and Git to back up to Person version 2? Right-click on the version 2 commit and choose Reset.

 

Select “Soft (HEAD Only)” to revert to version 2 only in the HEAD file set. This leaves the Index and the Working Directory still on version 3. As a result, the History view changes to reflect the fact that the HEAD now points to Person version 2:

 

And, since the Index and Working Directory still have version 3, the Git Staging view shows that version in the Staged Changes, ready to work on some more in the Working Directory, or commit again.

 

A Mixed Reset affects both the HEAD and the Index versions of the file. Selecting this option alters the History view the same as the Soft Reset above, with the version 3 commit reverted and therefore disappearing. Since the HEAD and Index now have version 2 again, but the Working Directory was not affected by this reset, the file now reappears in the Git Staging view’s “Unstaged Changes” area.

 

A Hard Reset changes the file version in each of the three Git file sets: HEAD, Index and Working Directory. This effectively throws out an entire commit. It disappears from the History, and version 3 is replaced with version 2 in both the Index and the Working Directory as well. Since Eclipse EGit is about to change the Working Directory, it asks, “Are you sure?”

 

Selecting Yes will lose all changes that were made in version 3. They will be gone from the HEAD, the Index and the Working Directory.

 

The Hard Reset is the only time when Reset is dangerous. It is a powerful tool, but use with caution! The other scenarios above can be undone easily enough. But a Hard Reset overwrites the changes (almost) everywhere. If you know your way around the RefLog, you might be able to get it back, but then, why would you be reading this basic introduction to Git Reset?

 

Posted by 셋부터넷
,