10-15-2012
I see no reason to delete your post, you asked a question and got a useful answer, future people with the same question may find this thread useful.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have about 12 columns and 15 rows to be retrived from sybase isql command through unix. But when i output the sql into a file and see it, the formatting is going for a toss. can someone please suggest how can i get the result correctly in the output file ?
Thanks,
Sateesh (2 Replies)
Discussion started by: kotasateesh
2 Replies
2. Web Development
I have following.
.
.
.
$userid = 2
.
$query = "select username from users where userid = ".$userid.";";
.
$username = $line;
$data="Some Data Here";
.
$query = "insert into logger (username, data) valuse ($username, $data);";
.
I would like to not have 2 database calls. (3 Replies)
Discussion started by: Ikon
3 Replies
3. Shell Programming and Scripting
Dear All ,
I have file1.txt contain values like the following:
----------
23
24
25
and I have shell script which has the following :
more file1.txt | awk '{print "select 'DUMP',CODE1||'|'||CODE2||'|'||CODE3 from CODE where CODE1='" $1 "';"}' > file2.sql
all I need is to have the... (6 Replies)
Discussion started by: habuzahra
6 Replies
4. Shell Programming and Scripting
count.sh#!/bin/ksh
SQL1=`sqlplus -s usr/pwd @count.sql $1 $2 $3`
SQL2=`sqlplus -s usr/pwd @selectall.sql $1 $2 $3`
LIST="Count Select_All"
select i in $LIST
do
if
then
echo $SQL1
elif
then
echo $SQL2
fi
done (2 Replies)
Discussion started by: killboy
2 Replies
5. Shell Programming and Scripting
Hi there
I have a database on a remote box and i have been using shell script to insert data into it for example, i could have a script that did this
SN=123456
n=server1
m=x4140
sql="UPDATE main SET hostname='$n',model='$m' WHERE serial='$SN';"
echo $sql |/usr/sfw/bin/mysql -h... (4 Replies)
Discussion started by: hcclnoodles
4 Replies
6. Shell Programming and Scripting
I know I know..
for sure one of the easier mysql statements. But somehow I can not figure out this.
I expect to see all distinct items of 'data_12' where 'kwroot' has 'straxx' in, and in the same row 'data_12' ist (not = 'kwsearched' in any existing row)
data_12 ... (6 Replies)
Discussion started by: lowmaster
6 Replies
7. Shell Programming and Scripting
i have a file of the form
9488 14392 1 1.8586e-07
5702 7729 1 1.8586e-07
9048 14018 1 1.8586e-07
5992 12556 1 1.8586e-07
9488 14393 1 1.8586e-07
9048 14019 1 1.8586e-07
5992 12557 1 1.8586e-07
9488 14394 ... (1 Reply)
Discussion started by: vaibhavkorde
1 Replies
8. Programming
Hello people,
as wrote in title I'm going crazy with a "complex" SQL select.
This is the seelct:
select T_ADDRESS, T_MCC,T_MNC,T_MSIN,T_IM_MNC, COUNT(*) FROM TABLETEST
WHERE T_MCC=123 AND (T_MNC=11 OR T_MNC=01)
GROUP BY T_ADDRESS,T_MCC,T_MNC,T_MSIN,T_IM_MNC HAVING count(*) > 5;This select... (7 Replies)
Discussion started by: Lord Spectre
7 Replies
9. Programming
Hi All,
I had a query related to sql select replace command.
i have a table named clusters and it looks like this
Code:
name characteristics
sample 1.1 parent
sample 1.2 ... (2 Replies)
Discussion started by: siya@
2 Replies
10. Shell Programming and Scripting
Hi Forum.
Need your expertise on the following question.
I have the following file which I would like to parse, find first block of SELECT statment and concatenate all input fields as 1 field (~ delimited):
Old File:
SELECT /*+ USE_HASH(CCOMM ICAR IMAP IAS IP IMAS IMPS IAP SPCA) */
... (5 Replies)
Discussion started by: pchang
5 Replies
QUIZ(6) BSD Games Manual QUIZ(6)
NAME
quiz -- random knowledge tests
SYNOPSIS
quiz [-t] [-i file] [question answer]
DESCRIPTION
The quiz utility tests your knowledge of random facts. It has a database of subjects from which you can choose. With no arguments, quiz
displays the list of available subjects.
The options are as follows:
-t Use tutorial mode, in which questions are repeated later if you didn't get them right the first time, and new questions are presented
less frequently to help you learn the older ones.
-i Specify an alternative index file.
Subjects are divided into categories. You can pick any two categories from the same subject. quiz will ask questions from the first cate-
gory and it expects answers from the second category. For example, the command ``quiz victim killer'' asks questions which are the names of
victims, and expects you to answer with the cause of their untimely demise, whereas the command ``quiz killer victim'' works the other way
around.
If you get the answer wrong, quiz lets you try again. To see the right answer, enter a blank line.
Index and Data File Syntax
The index and data files have a similar syntax. Lines in them consist of several categories separated by colons. The categories are regular
expressions formed using the following meta-characters:
pat|pat alternative patterns
{pat} optional pattern
[pat] delimiters, as in pat[pat|pat]pat
In an index file, each line represents a subject. The first category in each subject is the pathname of the data file for the subject. The
remaining categories are regular expressions for the titles of each category in the subject.
In data files, each line represents a question/answer set. Each category is the information for the question/answer for that category.
The backslash character (``'') is used to quote syntactically significant characters, or at the end of a line to signify that a continuation
line follows.
If either a question or its answer is empty, quiz will refrain from asking it.
FILES
/usr/share/games/bsdgames/quiz The default index and data files.
BUGS
quiz is pretty cynical about certain subjects.
BSD
May 31, 1993 BSD