Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: MYSQL Query for last twelve months of records
Top Forums UNIX for Beginners Questions & Answers MYSQL Query for last twelve months of records Post 303005087 by mojoman on Thursday 12th of October 2017 02:21:20 PM
Old 10-12-2017
MYSQL Query for last twelve months of records
Hi I am trying to run a MYSQL query to display all records within a 12 month period. I have to use from_unixtime function to great a date object.

Code:
select call_start_time from call_detail_records
 where call_start_time IN (
   select from_unixtime(call_start_time) from call_detail_records
    where from_unixtime(call_start_time) < Now()
    and from_unixtime(call_start_time) < DATE_ADD(Now(),INTERVAL- 12 MONTH)
   );

The query is syntactically correct but mysql returns no records when there are some. Can someone help?
Last edited by rbatte1; 10-13-2017 at 08:18 AM.. Reason: Split SQL onto multiple lines for clarity
 

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

mysql help : query with 2 conditionals

Hi there, I have a table that stores multiple records for many different servers, each of which is timestamped ... I wanted to write a query that would enable me to only output the "latest" record (based on timestamp) for each "unique" server. So for example my main table looks like this ... (3 Replies)
Discussion started by: hcclnoodles
3 Replies

3. 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

4. Web Development

Updating Records in Mysql Database

so when i issue a command like the below: # mysql --pager=/usr/bin/less -u cactiman -p -e 'select * from data_input' cacti Enter password: ... (2 Replies)
Discussion started by: SkySmart
2 Replies

5. Shell Programming and Scripting

mysql query in shellscript

Hi, I want to access mysql query from database , for that i have tried the below code #! /bin/bash TABLE_NAME=database1 USER_NAME=root IP_ADDR=111.20.9.256 somevar=`echo "select altid from alert where altid='2724'"| mysql -h $IP_ADDR -u $USER_NAME $TABLE_NAME ` echo $somevar ... (1 Reply)
Discussion started by: aish11
1 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

mysql query multiple records for one field

Hello Group, What I have is a database with about a dozen fields and one being "City". What I would like to do is to have a custom query on a single field for multiple items (cities) but I don't know how to do this. I know this is probably kids play for most of you but I am lost. What I have... (4 Replies)
Discussion started by: vestport
4 Replies

8. 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

LEARN ABOUT PHP

udm_find

UDM_FIND(3)								 1							       UDM_FIND(3)

udm_find - Perform search

SYNOPSIS

       resource udm_find (resource  $agent, string  $query)

DESCRIPTION

	Performs a search.

	The search itself. The first argument - session, the next one - query itself. To find something just type words you want to find and press
       SUBMIT button. For example, "mysql odbc". You should not use quotes " in query, they are written here only to divide  a	query  from  other
       text.  mnoGoSearch  will find all documents that contain word "mysql" and/or word "odbc". Best documents having bigger weights will be dis-
       played first. If you use search mode ALL, search will return documents that contain both (or more) words you entered. In case you use  mode
       ANY,  the  search  will	return	list of documents that contain any of the words you entered. If you want more advanced results you may use
       query language. You should select "bool" match mode in the search from.

PARAMETERS

	      o $agent
		- A link to Agent, received after call to udm_alloc_agent(3).

	      o $query
		- mnoGoSearch understands the following boolean operators:  & - logical AND. For example, "mysql & odbc".  mnoGoSearch	will  find
		any  URLs  that  contain  both "mysql" and "odbc".  | - logical OR. For example "mysql|odbc". mnoGoSearch will find any URLs, that
		contain word "mysql" or word "odbc".  ~ - logical NOT. For example "mysql & ~odbc". mnoGoSearch will find URLs that  contain  word
		"mysql"  and  do  not  contain word "odbc" at the same time. Note that ~ just excludes given word from results. Query "~odbc" will
		find nothing!  () - group command to compose more complex queries. For example "(mysql | msql) &  ~postgres".  Query  language	is
		simple and powerful at the same time. Just consider query as usual boolean expression.

RETURN VALUES

	Returns a result link identifier on success or FALSE on failure.

PHP Documentation Group 													       UDM_FIND(3)
All times are GMT -4. The time now is 11:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy