|
|
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
dbix::searchbuilder::handle::mysql
DBIx::SearchBuilder::Handle::mysql(3pm) User Contributed Perl Documentation DBIx::SearchBuilder::Handle::mysql(3pm) NAME
DBIx::SearchBuilder::Handle::mysql - A mysql specific Handle object SYNOPSIS
DESCRIPTION
This module provides a subclass of DBIx::SearchBuilder::Handle that compensates for some of the idiosyncrasies of MySQL. METHODS
Insert Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted. If the insert succeeds, returns the id of the insert, otherwise, returns a Class::ReturnValue object with the error reported. SimpleUpdateFromSelect Customization of "SimpleUpdateFromSelect" in DBIx::SearchBuilder::Handle. Mysql doesn't support update with subqueries when those fetch data from the table that is updated. DatabaseVersion Returns the mysql version, trimming off any -foo identifier CaseSensitive Returns undef, since mysql's searches are not case sensitive by default SimpleDateTimeFunctions Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle. ConvertTimezoneFunction Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle. Use the following query to get list of timezones: SELECT Name FROM mysql.time_zone_name; Read docs about keeping timezone data up to date: http://dev.mysql.com/doc/refman/5.5/en/time-zone-upgrades.html AUTHOR
Jesse Vincent, jesse@fsck.com SEE ALSO
DBIx::SearchBuilder, DBIx::SearchBuilder::Handle perl v5.14.2 2011-09-21 DBIx::SearchBuilder::Handle::mysql(3pm)