MySqlの例

php

CREATE INDEX DlDateIndex ON sp_MailMagazine (DlDate)

CREATE UNIQUE INDEX DlDateIndex ON sp_MailMagazine (DlDate)

DROP INDEX DlDateIndex ON sp_MailMagazine

DROP INDEX ON sp_MailMagazine


show index from sp_MailMagazine

select DlDate from sp_MailMagazine ORDER BY DlDate DESC


select DLDate from sp_MailList where DLDate='2008-02-08 14:00:15' ORDER BY DLDate DESC

$MailList .= "\"" . $value_MailAddress . "\",\n";

select `MailRegDate` from `sp_MailList` ORDER BY MailRegDate DESC limit 1