How to clear the holiday data?

[CapriSkye]

does anyone know the sql command to clear the holiday data? not the table itself, but the data inside it. thanks

[Grudge]

EMPTY TABLE tablename

[[Unknown]]

TRUNCATE TABLE, you mean?

-[Unknown]

[CapriSkye]

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......

[[Unknown]]

TRUNCATE TABLE real_prefix_calendar_holidays;

Remember, MySQL doesn't magically recognize "{$db_prefix}".

-[Unknown]

[CapriSkye]

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.

[A.M.A]

Split into a new topic.