How would I benifit from a stored procedure?
Stored procedures live with your data and can be called
directly from inside queries. They can be customized to do what
you want to the data before mysql gives it to you (SELECT) or after you
feed it in, which is what you want for an insert.
so your
This one time, at band camp, Sasha Pachev <[EMAIL PROTECTED]> wrote:
> * if your application is not going to be deployed for a year or so or if you
> have enough confidence in MySQL alpha, use stored procedures in the bleeding
> edge MySQL 5.0
How would I benifit from a stored procedure?
Kind
This one time, at band camp, Mark Maggelet <[EMAIL PROTECTED]> wrote:
> I don't know how you're charging weekly rates, but you could just
> check if daysbooked>=7 and knock a percentage off total.
I was thinking of having each day of a period charged as
the weekly period rate divided by 7. But t
Kevin Waterson wrote:
I am (trying) to make a booking systems.
Currently I have a table with 3 timestamps that record
bookingDate, bookingFromDate and bookingToDate
I have another table that records 'seasons'.
This table contains two timestamps that record
seasonStartDate and seasonEndDate
also I h
here's a quick and dirty way to do it:
1) make the seasons table look like this:
dayofyear int
season enum('winter','spring','summer','fall')
rate decimal(5,2)
2) populate 'seasons' with 1-366 for dayofyear and the corresponding
season and daily rate.
3) to get the total rate do a query like:
Kevin Waterson wrote:
I am (trying) to make a booking systems.
Currently I have a table with 3 timestamps that record
bookingDate, bookingFromDate and bookingToDate
I have another table that records 'seasons'.
This table contains two timestamps that record
seasonStartDate and seasonEndDate
also I h
