Sponsored Content
Top Forums Shell Programming and Scripting mysql help : query with 2 conditionals Post 302371946 by rdcwayx on Monday 16th of November 2009 07:20:30 PM
Old 11-16-2009
some clues for you.

First to convert the date (for example, change from 11-JUN to 11-06) will be more easy for sort -k
 

8 More Discussions You Might Find Interesting

1. Programming

How to query one to many mysql

Hi there, I have a hierarchical database that include 4 tables. Table A is the parent of B, B is Parent of C, C is parent of D. If I want to query everything in D that is associated with A.name, how do I do that? Thanks! YanYan (0 Replies)
Discussion started by: pinkgladiator
0 Replies

2. Shell Programming and Scripting

? parameter in mysql query

I am debugging some code and came across ? in the WHERE cause in a mysql query. Is this possible and what situations would this be used? SELECT ip, count FROM table WHERE domain=? thanks & regards (2 Replies)
Discussion started by: hazno
2 Replies

3. Web Development

Complex MySQL Query(s)

Hi all, I have a bit of an issue, I am working on a bit of a CMDB for a friend, it's to do with real estate. Anyway, this is my situation. I have a table which contains all the properties (forsale, sold, etc) in the DB named "property". Now, this is what I want to achieve, I wish to... (5 Replies)
Discussion started by: STOIE
5 Replies

4. Web Development

mysql query help

hello all i have 2 columns every column in the following format column1 2011-04-01 11:39:54 column2 2019-02-03 00:00:00 i want get difference between above data as following 2 days 11:39 how to do so ? i tried many functions but nothing works please advice what is the query... (6 Replies)
Discussion started by: mogabr
6 Replies

5. Shell Programming and Scripting

mysql query in shellscript

Hi, I want to run below query on shellscript but having one problm. ADV=$( mysql -h "$IP_ADDR" -u "$USER_NAME" "$TABLE_NAME" -BNe" SELECT ADV FROM indata where inid='$INSTRUID' and Date='$latest Date';" ) here Date column contans different below dates 2011-12-01... (11 Replies)
Discussion started by: aish11
11 Replies

6. Programming

mysql query help

Hello i have created mysql query to compare to values and get difference in percentage as following: SELECT file_name, 100 - ((100 * (SELECT file_count FROM xipi_files z WHERE x.file_group = z.file_group AND x.file_name = z.file_name AND z.insert_date = CURDATE( ) - INTERVAL 1 DAY)) /... (1 Reply)
Discussion started by: mogabr
1 Replies

7. Programming

Need help in mysql query

Hi All, i have a table in mysql with the following data Table name Test Assettype Serial_No Status location Mouse 123456 In Stock chennai Mouse 98765 Allocated chennai Keyboard ... (2 Replies)
Discussion started by: venkitesh
2 Replies

8. Shell Programming and Scripting

Need wrapper around mysql query

Hello Friends, I am using check_mysql_query plugin in nagios to query database and get output. query is working fine but output which i am getting contain query. I want to remove query from output and give custom message which will be simple and understandable. Can you help me here with any... (5 Replies)
Discussion started by: ghpradeep
5 Replies
SWISS::DTs(3pm) 					User Contributed Perl Documentation					   SWISS::DTs(3pm)

Name
       SWISS::DTs

Description
       SWISS::DTs represents the DT lines within an Swiss-Prot + TrEMBL entry as specified in the user manual
       http://www.expasy.org/sprot/userman.html .

Inherits from
       SWISS::BaseClass.pm

Attributes
       "CREATED_date"
	   Creation date

       "ANN_date"
	   Last annotation update

       "SQ_date"
	   Last Sequence update

       "CREATED_rel"
	   Created for release

       "ANN_rel"
	   Last annotation for release

       "SQ_rel"
	   Last sequence update for release

       "ANN_version"
	   Version number for entry annotation

       "SQ_version"
	   Version number for sequence

Methods
   Standard methods
       new
       fromText
       toText
       sort

   Writing methods
       set_Created ($date, $release)
       set_AnnotationUpdate ($date, $release[, $version])
       set_SequenceUpdate ($date, $release[, $version])

TRANSITION
The format of the DT line will change in early 2004 from: DT 01-JUL-1993 (Rel. 26, Created) DT 01-JUL-1993 (Rel. 26, Last sequence update) DT 28-FEB-2003 (Rel. 41, Last annotation update) to: DT 01-JUL-1993, integrated into UniProtKB/Swiss-Prot. DT 01-JUL-1993, sequence version 36. DT 28-FEB-2003, entry version 54. This module supports both formats. To convert an entry from the old to the new format, do: $entry->DTs->CREATED_rel("UniProtKB/Swiss-Prot"); $entry->DTs->ANN_version(54); $entry->DTs->SQ_version(36); perl v5.10.1 2008-07-11 SWISS::DTs(3pm)
All times are GMT -4. The time now is 09:25 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy