MySQL :: Re: Select last row that is less than or equal to a date

New Topic

Re: Select last row that is less than or equal to a date

Posted by: David Marcus
Date: January 30, 2013 05:50PM

SHOW SESSION STATUS LIKE 'Created_tmp_tables';
"Created_tmp_tables","1"

select * from History where HistoryPlayer = 59161 and HistoryDate <= '2012-01-01' order by HistoryDate desc limit 0,1;

One row returned.

SHOW SESSION STATUS LIKE 'Created_tmp_tables';
"Created_tmp_tables","2"

Why is it creating a temporary table?

Do I have to uninstall 5.5 to install the 5.6 Release Candidate?

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

Select last row that is less than or equal to a date

6944

David Marcus

January 23, 2013 06:35PM

Re: Select last row that is less than or equal to a date

2127

Rick James

January 24, 2013 10:27PM

Re: Select last row that is less than or equal to a date

2060

David Marcus

January 26, 2013 09:35AM

Re: Select last row that is less than or equal to a date

1843

Rick James

January 27, 2013 10:19AM

Re: Select last row that is less than or equal to a date

2091

David Marcus

January 27, 2013 12:00PM

Re: Select last row that is less than or equal to a date

1749

Rick James

January 29, 2013 12:51AM

Re: Select last row that is less than or equal to a date

1795

David Marcus

January 29, 2013 06:28PM

Re: Select last row that is less than or equal to a date

2253

Øystein Grøvlen

January 30, 2013 04:50AM

Re: Select last row that is less than or equal to a date

1755

David Marcus

January 30, 2013 05:50PM

Re: Select last row that is less than or equal to a date

1704

Øystein Grøvlen

February 01, 2013 06:03AM

Re: Select last row that is less than or equal to a date

1812

David Marcus

February 02, 2013 07:14AM

Re: Select last row that is less than or equal to a date

1679

Øystein Grøvlen

February 02, 2013 01:49PM

Re: Select last row that is less than or equal to a date

1733

David Marcus

February 02, 2013 02:25PM

Re: Select last row that is less than or equal to a date

1623

Øystein Grøvlen

February 03, 2013 05:58AM

Re: Select last row that is less than or equal to a date

1661

David Marcus

February 03, 2013 10:04AM

Re: Select last row that is less than or equal to a date

1750

Rick James

February 03, 2013 10:43AM

Re: Select last row that is less than or equal to a date

2311

David Marcus

February 03, 2013 12:33PM

Re: Select last row that is less than or equal to a date

1715

Rick James

February 03, 2013 02:59PM

Re: Select last row that is less than or equal to a date

1875

David Marcus

February 03, 2013 03:35PM

Re: Select last row that is less than or equal to a date

1809

Rick James

February 03, 2013 04:02PM

Re: Select last row that is less than or equal to a date

1795

David Marcus

February 03, 2013 04:15PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.