does anyone know the sql command to clear the holiday data? not the table itself, but the data inside it. thanks
EMPTY TABLE tablename
TRUNCATE TABLE, you mean?
-[Unknown]
i want to clear all the holidays in calendar_holidays table, like ben mentioned in his post. so if i execute the sql file in mysql, it would clear the data first, then insert all the new holidays.
EMPTY doesn't seem to work, and i can't find anything related to that in mysql manual.
this is what i did,
EMPTY TABLE {$db_prefix}calendar_holidays
INSERT INTO......
TRUNCATE TABLE real_prefix_calendar_holidays;
Remember, MySQL doesn't magically recognize "{$db_prefix}".
-[Unknown]
yeah i just found that out right now, but with errors where INSERT is, so i guess i have to change {db_prefix} too. thanks unknown.
Split into a new topic.