|
|
Sponsored Content
Operating Systems
Solaris
Mysql query reading a text file.
Post 302382377 by jyothi_wipro on Wednesday 23rd of December 2009 05:39:34 AM
12-23-2009
Mysql query reading a text file.
Hi,
Is there any way that mysql query reads the content from a text file which has data in the below format:
1,2,3,4,5
and selects matched data from another table.
ie I have a table named xyz which has same ids as in that file.
I want this query to get count of the ids from xyz file by matching the ids.
At mysql prompt i run this command which gets me the count from xyz table.
mysql>select count(*) from xyz where id in (1,2,3,4,5);
Now i want the sql query to read the file and match these ids with ids in xyz table and get me the count.
Is there any way that mysql query reads the content from a text file which has data in the below format:
1,2,3,4,5
and selects matched data from another table.
ie I have a table named xyz which has same ids as in that file.
I want this query to get count of the ids from xyz file by matching the ids.
At mysql prompt i run this command which gets me the count from xyz table.
mysql>select count(*) from xyz where id in (1,2,3,4,5);
Now i want the sql query to read the file and match these ids with ids in xyz table and get me the count.
|
|
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
font::ttf::coverage
Font::TTF::Coverage(3pm) User Contributed Perl Documentation Font::TTF::Coverage(3pm) NAME
Font::TTF::Coverage - Opentype coverage and class definition objects DESCRIPTION
Coverage tables and class definition objects are virtually identical concepts in OpenType. Their difference comes purely in their storage. Therefore we can say that a coverage table is a class definition in which the class definition for each glyph is the corresponding index in the coverage table. The resulting data structure is that a Coverage table has the following fields: cover A boolean to indicate whether this table is a coverage table (TRUE) or a class definition (FALSE) val A hash of glyph ids against values (either coverage index or class value) fmt The storage format used is given here, but is recalculated when the table is written out. count A count of the elements in a coverage table for use with add. Each subsequent addition is added with the current count and increments the count. METHODS
new($isCover [, vals]) Creates a new coverage table or class definition table, depending upon the value of $isCover. if $isCover then vals may be a list of glyphs to include in order. If no $isCover, then vals is a hash of glyphs against class values. read($fh) Reads the coverage/class table from the given file handle out($fh, $state) Writes the coverage/class table to the given file handle. If $state is 1 then the output string is returned rather than being output to a filehandle. $c->add($glyphid[, $class]) Adds a glyph id to the coverage table incrementing the count so that each subsequent addition has the next sequential number. Returns the index number of the glyphid added $c->signature Returns a vector of all the glyph ids covered by this coverage table or class @map=$c->sort Sorts the coverage table so that indexes are in ascending order of glyphid. Returns a map such that $map[$new_index]=$old_index. $c->out_xml($context) Outputs this coverage/class in XML AUTHOR
Martin Hosken Martin_Hosken@sil.org. See Font::TTF::Font for copyright and licensing. perl v5.10.1 2011-02-25 Font::TTF::Coverage(3pm)