Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Select record with MAX value in MySQL
Top Forums Shell Programming and Scripting Select record with MAX value in MySQL Post 302433639 by radoulov on Wednesday 30th of June 2010 07:02:39 AM
Old 06-30-2010
I understand,
why don't you just update the files table at the end of each file processing? A single record update vs scheduled mass update.

P.S. If I understand correctly the last time update in the files table is the slowest part, right?
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Select Record based on First Column

Hi, I have a file with multiple records...and I have to select records based on first column....here is the sample file... I01,abc,125,1a2,LBVI02 I01,abc,126,2b5,LBVI02 I02,20070530,254,abc,LLBI01 I02,20070820,111,bvd,NGBI01 I need all records with I01 in first field in one file and... (8 Replies)
Discussion started by: mgirinath
8 Replies

2. Shell Programming and Scripting

mysql select query optimization..

hi.. i need to optimize my select query .. my situation is like this .. i have 15 lac recors in my table.. the following query takes nine seconds to give the required output.. SELECT max(ah.AUC_AMT), SUBSTRING_INDEX(GROUP_CONCAT(SUBSTRING_INDEX(ah.AUC_CUS_NAME,'@',1) order by AUC_AMT... (0 Replies)
Discussion started by: senkerth
0 Replies

3. UNIX for Advanced & Expert Users

mysql select query optimization..

hi.. i need to optimize my select query .. my situation is like this .. i have 15 lac recors in my table.. the following query takes nine seconds to give the required output.. SELECT max(ah.AUC_AMT), SUBSTRING_INDEX(GROUP_CONCAT(SUBSTRING_INDEX(ah.AUC_CUS_NAME,'@',1) order by AUC_AMT... (1 Reply)
Discussion started by: senkerth
1 Replies

4. UNIX for Dummies Questions & Answers

Select max value based on filename

Hi, I would just like to know how to get the file with the max filename on a directory and get rid of all the others. For example, in directory A:/ i have the ff files: APPLE2001 APPLE2002 APPLE2003 GRAPE2004 what I want to get is the max in files whose filenames start with APPLE*,... (4 Replies)
Discussion started by: madden
4 Replies

5. Shell Programming and Scripting

Max value Record from a File

I have a file with 3 columns I want to get the record with the max salary. If there are more than 1 record having the highest salary, i want any one of them. empid,ename,Sal 1,abc,100 2,def,200 3,xyz,300 4,pqr,100 5,mnq,300 Output Any record with 300 as salary Please use next... (1 Reply)
Discussion started by: traininfa
1 Replies

6. Programming

Getting Rows from a MySQL Table with max values?

I feel stupid for asking this because it seems that MYSQL code isn't working the way that I think it should work. Basically I wrote code like this: select * from `Test_DC_Trailer` HAVING max(DR_RefKey); Where the DR_RefKey is a unique numeric field that is auto iterated (like a primary key)... (7 Replies)
Discussion started by: Astrocloud
7 Replies

7. Shell Programming and Scripting

Select record having different value in second column

I want records which have more than one and different value in the second column on the below sample file. Ex, I have the samle file below :- XYZ 1 XYZ 3 abc 1 abc 1 qwe 2 qwe 1 qwe 3 I want to select XYZ and QWE line only. (6 Replies)
Discussion started by: Sanjeev Yadav
6 Replies

8. Programming

MySQL select user with the same IP address

Dear community, I woul like to make a query to output all the users having the same IP address. The table is somethig like: name logged_ip ==== ========= user1 127.0.0.1 user2 127.0.0.2 user3 127.0.0.3 user4 127.0.0.1 user5 127.0.0.2 user6 127.0.0.5I used this query... (4 Replies)
Discussion started by: Lord Spectre
4 Replies

9. Shell Programming and Scripting

Script to record max memory usage of program

Hello, I am working on an application that uses allot of memory depending on the input. I am also working on more than one processing algorithm. The program has a long processing time (hours) so it would be nice to be able to monitor the maximum memory footprint of the application during runs... (1 Reply)
Discussion started by: LMHmedchem
1 Replies

LEARN ABOUT DEBIAN

update-xmlcatalog

UPDATE-XMLCATALOG(8)						     xml-core						      UPDATE-XMLCATALOG(8)

NAME

       update-xmlcatalog - maintain XML catalog files

SYNOPSIS

       update-xmlcatalog --add --root --package package --type type --id id

       update-xmlcatalog --del --root --package package --type type --id id

       update-xmlcatalog --add --package package --local local --type type --id id

       update-xmlcatalog --del --package package --local local --type type --id id

       update-xmlcatalog --add --local local --file file --type type --id id

       update-xmlcatalog --del --local local --file file --type type --id id

       update-xmlcatalog --help

DESCRIPTION

       update-xmlcatalog add entries to and removes entries from the root XML catalog file, a package XML catalog file or a local XML catalog
       file.

OPTIONS

       --add
	   Adds the entry to the root XML catalog file, a package XML catalog file or a local XML catalog file.  If the XML catalog file does not
	   exist yet, it is automatically created.

       --del
	   Deletes the entry from the root XML catalog file, the package XML catalog file or the local XML catalog file.  A resulting empty XML
	   catalog is not automatically deleted from the filesystem.

       --file file
	   Indicates a local filename.

       --id id
	   Indicates the XML catalog file entry identifier.

       --local local
	   Indicates a local XML catalog file.

       --package package
	   Indicates a package XML catalog file.

       --root
	   Indicates the root XML catalog file.

       --type type
	   Indicates the XML catalog file entry type (public, system, uri).

       --help
	   Displays the usage information.

NOTES

       update-xmlcatalog is the de-facto standard tool to be used to maintain XML catalog files on a Debian system, similar to that
       update-catalog(8) is the standard tool to be used to main SGML catalog files on a Debian system.  A Debian XML Policy document to this
       effect is currently under development.

       update-xmlcatalog and xmlcatalog(1) are incompatible.  The former has an internal database of all the entries in all the XML catalog files
       it maintains and regenerates the indicated XML catalog file completely from scratch upon an update.  The latter updates the indicated XML
       catalog file directly.  This means that any change made to an XML catalog file using xmlcatalog(1) is overwritten the next time that XML
       catalog file is updated using update-xmlcatalog.

SEE ALSO

       /usr/share/doc/xml-core/README.Debian

AUTHOR

       Ardo van Rangelrooij <ardo@debian.org>

perl v5.14.2							    2008-10-14						      UPDATE-XMLCATALOG(8)
All times are GMT -4. The time now is 08:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy