The maximum value for decimal(5,3) is 99.999, it means 5 digits with 3 digits after decimal, and whenever you try to insert or update more than 99.999 value it is automatically capped to 9.99 in mysql. This Try decimal(5, 2) Decimal(5,3) is used for financial values or less than 100% values. If you want to […]
Check below on How to Add a Column to Mysql Table with Auto Increment and Primary Key You can achieve it by doing Alter Command: Add Column to Mysql To Modify Column and add Auto Increment with Primary Key Query: ALTER TABLE test MODIFY COLUMN ID INT(10) PRIMARY KEY auto_increment; ALTER TABLE users ADD id […]
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
