If you are working on a big mysql query and want to get the mysql query as email when it finishes use the below trick. Go to mysql command:Set pager directive: mysql> pager mail -s “subject” emailme@domain.comPAGER set to ‘mail’ -s “subject” emailme@domain.com The trick uses pager directive to redirect the query output result to […]
If you are looking for a RRULE EXDATE Ical example file for a Recurring Event then check below. Ical Recurring Event Example BEGIN:VCALENDAR PRODID:-//Microsoft Corporation//Outlook 9.0 MIMEDIR//EN VERSION:2.0 CALSCALE:GREGORIAN METHOD:PUBLISH BEGIN:VEVENT DTSTART:20190922T023000Z DTSTAMP:20190922T023611Z RRULE:FREQ=WEEKLY;INTERVAL=1;UNTIL=20151122T033000Z UID:1780 Location:AP Test DESCRIPTION:test LAST-MODIFIED:20190922T023611Z SEQUENCE:0 STATUS:CONFIRMED SUMMARY: service TRANSP:OPAQUE END:VEVENT END:VCALENDAR
You can find duplicate rows in the mysql table, just use below select query, to find duplicate rows in Oracle, Sql, Mysql, DB2. SELECT columnName, COUNT(*) as countFROM selectedTableGROUP BY columnNameHAVING COUNT(*) > 1; You came from below query:how to find duplicate rows in sql server 2008how to find duplicate rows in sql and deletehow […]
