How to clear the holiday data?

Started by CapriSkye, November 06, 2004, 01:45:06 PM

Previous topic - Next topic

CapriSkye

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

Grudge

I'm only a half geek really...

[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

Really sorry .. real life is demanding my full attention .. will be back soon hopefully :)

Advertisement: