Hello all,
I have a little table o TAs (teach assistants) with the following MySQL
schema:
tbl_NotAvailable {
TAid - int(11)
StartDate - DateTime
EndDate - DataTime
}
This table logs the times where TAs are NOT available. So If a TA is not
available on Monday from 12:00 to Tuesday
C.F. Scheidecker Antunes wrote:
Question one:
Now, how can I return a calendar of the dates where the TA is AVAILABLE,
that is the oposite of what is recorded?
I want a list of all the available days and times by substracting the
non available times recorded in the table.
I guess I would need
Hello,
I try to create an application for my dissertation that caches rows from
an romote database. The application handles a cache database which is
identical with the original. The only difference is that it does not
have autogenerated fields and referential integrity is omitted.
I have
Hi,
Try in in two fold.
1. Get all the ID you have in your remote DB
2. check those localy with the ones you have in cache
3. Get all the info you need after you remove the ID you already have.
2005/8/14, Kostas Karadamoglou [EMAIL PROTECTED]:
Hello,
I try to create an application for my
I thought this solution but it needs an extra software at the remote
database. I would prefer to contact from the cache database directly to
the remote database using SQL.
But even using those 3 steps there is a problem. The only interface that
I have is JDBC/SQL. That means that the only
CF,
tbl_NotAvailable {
TAid - int(11)
StartDate - DateTime
EndDate - DataTime
}
snip
Question one:
Now, how can I return a calendar of the dates where the TA is AVAILABLE,
that is the oposite of what is recorded?
You may be better off with an explicit calandar table containing slots
Always reply to the lists, others may have better ideas, others insights...
I may have not understand everything in your previous description. Why
would you need an extra software on the remote DB ??
All the steps I've describe should work from the client.
All you want is a kind of cache for the
Brian Dunning [EMAIL PROTECTED] wrote:
Have a look here, but use that OS which you know better:
http://dev.mysql.com/doc/mysql/en/windows-vs-unix.html
Same machine, any performance difference?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This
I just revived a database that was in a version 3.23 server and moved it
to a 4.1 There are big fields of TEXT based data. They have a way of
compressing the amount of TEXT data by identifying common subchunks and
putting them in a subchunk table and replacing them with a marker
inside the
Hi!
On Aug 09, Daniel Kasak wrote:
Hi all.
I've been testing out mysql-5.0.10 on my Powerbook ( Gentoo Linux PPC ),
and I've hit an incredibly unfortunate bug. It is demonstrated
adequately with the following:
...
Is anyone interested in examining what went wrong? ie should I create a
Hi,
I use ther version 4.1.11, and when I run this query :
SELECT c.id,c.subject,c.res_type,c.news_id,c.com_thread,c.timestamp +
0 as timestamp FROM comments c WHERE c.id IN (SELECT d.id FROM
comments d WHERE d.res_type=1 GROUP BY d.news_id ORDER BY d.id DESC
LIMIT 5 ) ORDER BY c.timestamp DESC;
Thanks for your answer. It would certainly work provided having
enough disk space to do that. I thought something like
that but was hoping I can leverage fulltext and just
record the fulltext result between a each record
and each other record. Then I can group all records that
highly correlate
I need to drop a database named ÃáãÃáà using the mysql client. I'm
getting you have an error in your sql syntax for the command
DROP database ÃáãÃáÃ;
I'm sure this is a character set issue. How can I drop this database?
Regards,
Gary H.
--
MySQL General Mailing List
For list
You can modify the algorithm I proposed to find groups of records that
are likely to have duplicate chunks. Simply record only a part of
hashes, something like: if md5(concat(word1,word2,...,word20))%32=0.
Disk usage for this table will be maybe 60 bytes per record, if your
average word is 8 bytes
Mysql's query cache has two option's [query_cache_limit] and [query_cache_size].
The documentation is not clear (for me) on their purpose and correct
usage tactics.
What does the [query_cache_size] sets, the maximum memory space a
single query can utilize ? Is it wise to set it to the same size
query_cache_size - a total size of memory that server utilizes for
query caching.
query_cache_limit - maximum size of result set that can be cached.
I'd suggest leaving query_cache_limit at 1 mb (the default value), and
tune query_cache_size until you have reasonably low
qcache_lowmem_prunes
Dear All,
I am trying to join two tables say a b. Both tables have a set
of dates. I want to join the tables in such a fashion that I retrieve
all dates from table A. If table b has corresponding data (for that
date) then it will display it or else will display null. I am pretty
sure that I
Hello:
OS: Linux Slackware 10.0
Ver: 4.0.20
Network Status: Closed to outside world
After installation:
I'm getting the following problems:
Login Problem:
mysql --host=localhost --user=root --password=**
ERROR 2002: Can't connect to local MySQL server through socket
18 matches
Mail list logo