12-23-2009
No
Its not possible.
Mysql client only reads from the db and not from just any text file. You would have to use a mediator like perl to fetch data from both sources and then compare.
---------- Post updated at 04:27 PM ---------- Previous update was at 04:27 PM ----------
No
Its not possible.
Mysql client only reads from the db and not from just any text file. You would have to use a mediator like perl to fetch data from both sources and then compare.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a text file with 50 munbers.
I wanna read these numbers and append "@yahoo.com" and send emails to them using shell scripting..........
How do i read the inetegres from the text file. (1 Reply)
Discussion started by: jaan
1 Replies
2. Shell Programming and Scripting
Guys,
I am trying to read text from a file, into arrays.
The format of the file is:
@DATABASE
femotest
@PACKAGE_SPECS
/usr/home/oracle92/sosa/scripts/test.pks
/usr/home/oracle92/sosa/scripts/rep.pks
@PACKAGE_BODIES
... (12 Replies)
Discussion started by: LiquidChild
12 Replies
3. UNIX for Dummies Questions & Answers
How can i have a while loop as follows
while read inputline
do
<task>
done < name_list
and also store the values (delimited) on each line to temp variables so as to print them on screen as follows
while read inputline
do
set name | cut -d "," -f1 name_list # #i know this is not... (1 Reply)
Discussion started by: bilal05
1 Replies
4. UNIX for Dummies Questions & Answers
Hi all,
Here is my problem. I want to read data from a file and pass the variable to a select query.
I tried but it doesn't seem to work. Please advise. Example below.
FileName='filekey.txt'
while read LINE
do
var=$LINE
print "For File key $var"
${ORACLE_HOME}/bin/sqlplus -s... (1 Reply)
Discussion started by: er_ashu
1 Replies
5. Programming
hello all ,
im trying to read a text file and display its contents. While i got the code running and the output was displayed perfectly for sometime , i started getting Abort(core dump) error . Am i missing something here ? im using HP-UX.
#include <iostream.h>
#include <fstream.h>
#include... (1 Reply)
Discussion started by: vishy_85
1 Replies
6. Shell Programming and Scripting
Hi,
I've a txt file with the following contents:
variable = "select name, emp_id, org_name "
variable = variable + " from table_name where "
variable = variable + " condition_1 = ABC and "
variable = variable + " condition_2 = DEF "
varaible = variable + " order by other condition "
... (7 Replies)
Discussion started by: arjun_arippa
7 Replies
7. Shell Programming and Scripting
Hi Guys,
I am having below file which holds data like this
file.txt
name,id,flag
apple,1,Y
apple,2,N
mango,1,Y
mango,2,Y
I need to read the above file and frame a query like this
hive -s -e "create apple_view as select 1 from main_table;"
hive -s -e "create mango_view as select... (11 Replies)
Discussion started by: rohit_shinez
11 Replies
8. Programming
Hello Team,
I have 2 files.one contains english text and another contains Japanese. so i have to read english text and replace the text with Japanesh text in third file.
Basically, I need a help to write japanese language in text/xml file.I heard wstring does this.Not sure how do i write... (2 Replies)
Discussion started by: SA_Palani
2 Replies
9. UNIX for Beginners Questions & Answers
I would like to call a .sql file from a .sh file in linux. The .sql file will contain queries to MySQL database.
I am able to call the .sql file by running .sh file in linux, but the sql query is not working. Below is my syntax. The select statement is throwing below error.
./sample.sql: line... (1 Reply)
Discussion started by: qytan
1 Replies
LEARN ABOUT DEBIAN
plucene::search::query
Plucene::Search::Query(3pm) User Contributed Perl Documentation Plucene::Search::Query(3pm)
NAME
Plucene::Search::Query - base class for queries
SYNOPSIS
my $s_query = Plucene::Search::Query::Subclass->new({
boost => $boost_factor});
my $scorer = $s_query->scorer($query, $searcher, $reader);
DESCRIPTION
This is an abstract base class for queries.
A query is a specification of the content an properties of the desired documents. Every search is done by matching a query against the
document index and locating the ones that match the query.
The simplest query specifies a single term (or word) that is to be matched against a single field (e.g. 'author') of each of the documents
in the index. This kind of query matches any document that contains the term in the specified field.
A more complex queries may contain nested queries with 'and', 'or', 'not' or 'phrase' relations. Queries may also contains specification of
which document fields to match against the various parts of the query (.e.g. 'authors' and 'title') and hints that may effects the ranking
of the matched documents ('boost' factor).
METHODS
new
my $s_query = Plucene::Search::Query::Subclass->new({
boost => $boost_factor});
boost
Get / set this attribute
scorer
my $scorer = $s_query->scorer
(Plucene::Search::Query $query, $searcher, $reader);
prepare
Does nothing
sum_squared_weights / normalize / _scorer
These must be defined in a subclass
perl v5.12.4 2011-08-14 Plucene::Search::Query(3pm)