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)
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)
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)
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)
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)
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)
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)
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 DEBIAN
search::gin::query::class
Search::GIN::Query::Class(3pm) User Contributed Perl Documentation Search::GIN::Query::Class(3pm)NAME
Search::GIN::Query::Class - Create class-based GIN queries
VERSION
version 0.08
SYNOPSIS
use Search::GIN::Query::Class;
my $query = Search::GIN::Query::Class->new(
class => 'Person',
);
DESCRIPTION
Creates a class-based GIN query that can be used to search records in a storage.
This is a ready-to-use query that uses class definitions (specifically "class", "does" and "blessed") to search through the storage.
METHODS /SUBROUTINES
new
Creates a new query.
ATTRIBUTES
class
The class of the object you want to find.
my $query = Search::GIN::Query::Class->new(
class => 'Person',
);
does
A role consumed by the object you want to find.
my $query = Search::GIN::Query::Class->new(
does => 'TheMonkey',
);
blessed
The name of the package that the object is blessed into.
my $query = Search::GIN::Query::Class->new(
blessed => 'Person',
);
AUTHOR
Yuval Kogman <nothingmuch@cpan.org>
COPYRIGHT AND LICENSE
This software is copyright (c) 2010 by Yuval Kogman, Infinity Interactive.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
perl v5.10.1 2011-01-31 Search::GIN::Query::Class(3pm)