Re: MySQL GROUP, ORDER problem.

2004-06-15 Thread John
>John: > >A couple of suggestions. First, a better way to identify duplicate files > in to >use MD5 sum - MySQL can compute it with MD5(LOAD_FILE(fname)) if the file > is >residing on the server. It would be a good idea to store the md5 sum in > the table. > >I think your problem can be solved with

Re: MySQL GROUP, ORDER problem.

2004-06-14 Thread Sasha Pachev
John: A couple of suggestions. First, a better way to identify duplicate files in to use MD5 sum - MySQL can compute it with MD5(LOAD_FILE(fname)) if the file is residing on the server. It would be a good idea to store the md5 sum in the table. I think your problem can be solved with CREATE TEMP

MySQL GROUP, ORDER problem.

2004-06-14 Thread John
Hello, do any body can help me, i have problem with mysql syntax may be. Let's first explain. I have two servers that i store filename, size ... in records of video camera files. I have one database with two tables: Servers and Files; Servers contain: ServerID, ServerName, User, Password, LastConne