Sponsored Content
Top Forums Programming Getting Rows from a MySQL Table with max values? Post 302633861 by Corona688 on Wednesday 2nd of May 2012 02:40:39 PM
Old 05-02-2012
Quote:
Originally Posted by 47shailesh
If we do "order by" than index is required.
I've fixed extremely slow order-by queries by adding appropriate indexes before; without them, it was forced to do a table scan, save to a temporary table, and sort after-the-fact, each step of which I could watch individually with the appropriate commands(something like 'show query status').

"Very poor performance" is not the same thing as "doesn't work at all".
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

max values amd min values

Hello every one, I have following data ***CAMPAIGN 1998 CONTRIBUTIONS*** --------------------------------------------------------------------------- NAME PHONE Jan | Feb | Mar | Total Donated ... (12 Replies)
Discussion started by: devmiral
12 Replies

2. Shell Programming and Scripting

select values from db1 table and insert into table of DB2

Hi I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.) I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies

3. Shell Programming and Scripting

Select record with MAX value in MySQL

Hi there, I have trouble selecting record that contain one biggest value for a group of other values. I mean, this is my table: mysql> SELECT * FROM b; +----+------+-------+ | id | user | value | +----+------+-------+ | 1 | 1 | 100 | | 3 | 1 | 150 | | 5 | 1 | 300 | | 6... (20 Replies)
Discussion started by: chebarbudo
20 Replies

4. Shell Programming and Scripting

Compare values in two files. For matching rows print corresponding values from File 1 in File2.

- I have two files (File 1 and File 2) and the contents of the files are mentioned below. - I am trying to compare the values of Column1 of File1 with Column1 of File2. If a match is found, print the corresponding value from Column2 of File1 in Column5 of File2. - I tried to modify and use... (10 Replies)
Discussion started by: Santoshbn
10 Replies

5. UNIX for Dummies Questions & Answers

get max value every 4 rows between 2 column

Hi all I have a file that has two columns and I need the maximum value in column 2 of 4 positions o rows. for example at position {1..3} there are 4 characters (A, C, G and T) each of these characters with a value with a value in column 2. I need the maximum value in column 2 and the corresponding... (2 Replies)
Discussion started by: xinox
2 Replies

6. Shell Programming and Scripting

Query the table and return values to shell script and search result values from another files.

Hi, I need a shell script, which would search the result values from another files. 1)execute " select column1 from table_name" query on the table. 2)Based on the result, need to be grep from .wft files. could please explain about this.Below is the way i am using. #!/bin/sh... (4 Replies)
Discussion started by: Rami Reddy
4 Replies

7. Shell Programming and Scripting

Retrieve multiple rows from mysql and automatically create a table

Hi, i want to create a table automatically based on another table (sms_key). For example; If user create a new row with sms_keyword field: IRC then a table created automatically (with some field on it, like: name, ph_number, messages). select * from sms_key; +-------------+ |... (1 Reply)
Discussion started by: jazzyzha
1 Replies

8. Shell Programming and Scripting

Median and max of duplicate rows

Hi all, plz help me with this, I want to to extract the duplicate rows (column 1) in a file which at least repeat 4 times. then I want to summarize them by getting the max , mean, median and min. The file is sorted by column 1, all the repeated rows appear together. If number of elements is... (5 Replies)
Discussion started by: ritakadm
5 Replies

9. Shell Programming and Scripting

awk file to read values from Db2 table replacing hard coded values

Hi, I want to replace a chain of if-else statement in an old AWK file with values from Db2 table or CSV file. The part of code is below... if (start_new_rec=="true"){ exclude_user="false"; user=toupper($6); match(user, "XXXXX."); if (RSTART ==2 ) { ... (9 Replies)
Discussion started by: asandy1234
9 Replies

10. Programming

Php number array from max, min, step size mysql data

I want to create a form with data values in a dropdown list. The values in the dropdown list need to be generated on the fly from max, min and increment values contained in a mysql database. Hopefully this makes sense, I really have no idea where to start :confused: Thanks (6 Replies)
Discussion started by: barrydocks
6 Replies
AXI-CACHE(1)							   User Commands						      AXI-CACHE(1)

NAME
axi-cache - query the Apt Xapian Index SYNOPSIS
axi-cache [options] command [args] DESCRIPTION
Query the Apt Xapian index. Commands: search commands: axi-cache again [query] repeat the last search, possibly adding query terms axi-cache help show a summary of commands axi-cache info print information about the apt-xapian-index environment axi-cache last [count] show the last results again axi-cache more [count] show more terms from the last search axi-cache rdetails pkgname[s] show details of reverse relationships for the given packages axi-cache search [terms] start a new search apt-cache front-ends: axi-cache depends pkgname[s] run apt-cache depends pkgname[s] axi-cache madison pkgname[s] run apt-cache madison pkgname[s] axi-cache policy pkgname[s] run apt-cache policy pkgname[s] axi-cache rdepends pkgname[s] run apt-cache rdepends pkgname[s] axi-cache show pkgname[s] run apt-cache show pkgname[s] axi-cache showpkg pkgname[s] run apt-cache showpkg pkgname[s] axi-cache showsrc pkgname[s] run apt-cache showsrc pkgname[s] OPTIONS
--version show program's version number and exit -h, --help show this help message and exit -s SORT, --sort=SORT sort by the given value, as listed in /var/lib/apt-xapian-index/values. Add a '-' to reverse sort order --tags show matching tags, rather than packages --tabcomplete=TYPE suggest words for tab completion of the current command line (type is 'plain' or 'partial') --last use 'show --last' to limit tab completion to only the packages from the last search results --all disable pagination and always show all results. Note that search results are normally sorted by relevance, so you may find meaning- less results at the end of the output axi-cache 0.44 September 2011 AXI-CACHE(1)
All times are GMT -4. The time now is 06:44 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy