Hm. I think this is more of a mount question. If you have two
machines, each with a /mysql/data directory then you cannot mount
/mysql/data from one machine to the other machine and have the
directories 'merge' into one big tree including 'all' contents. If you
mount overtop of a directory that
> >>I have a date range (start date and end date) supplied by the user
> >>and I also have information in a table that has start dates and
> >>end dates. I want to select everything in the table whose date range
> >>overlaps in any way with the date range given by the user.
> >Well... if you
Well... if you were given a start date of 2003-01-01 and end date of
2003-01-31...
select *
from table_name
where start_date between "2003-01-01" and "2003-01-31"
or end_date between "2003-01-01" and "2003-01-31"
No?
Matt.
On Wed, 2003-04-02 at 16:32, Sarah Heffron wrote:
> How would
If you added a timestamp column when you created the table then it's
easy... the timestamp column is updated automagically when an update or
insert is done.
create table tablename (id int, timestamp timestamp);
select timestamp from tablename where id = 123;
If you didn't use a timestamp column,
esn't exactly answer your question... sorry.
Matt Gostick.
On Mon, 2003-03-31 at 11:23, Dan Tran wrote:
>
> Hi, how do I configure mysql to be Case-Sensitive globally?
> (ie where, like, clauses work with case-sensitive strings
>
> Help is greatly appreciated.
>
> -Dan
>
