06-12-2012
Quote:
Originally Posted by
Linoleum
Thanks a lot, it works nicely since my STAT_CMD reads the stdin. Only a minor modification
So, you mean to say "temp.csv" is already sorted on field 3?
uniq works ONLY on sorted input.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a folder called {homedata}
Within this folder there are 12 subfolders 200601.......200612
Within each subfolder there are 8 sets of files
Each filename commences with A B C D E F G or H,
so {filename}* can be used.
I am trying to write a script which will from the top level
go... (1 Reply)
Discussion started by: grinder182533
1 Replies
2. Shell Programming and Scripting
Hello guys..
I have the following question.
lets have that i have the following variable:
$field=werfiurd383nd93bc93 c93 d93 d9e3 ddd
or
array=werfiurd383nd93bc93 c93 d93 d9e3 ddd
what i would like to do is to store the first 4 characters of gthe aboce variable in variable... (1 Reply)
Discussion started by: chriss_58
1 Replies
3. Shell Programming and Scripting
Hello guys,
I'm a new member here and I need some help with the Awk application. I'm using it through the Terminal app of OSX (I'm a Mac user).
I have a huge file with a large amount of data (rows of 3D cartesian coordinates). The data is typically like the following example (actually, the... (13 Replies)
Discussion started by: Cham
13 Replies
4. UNIX for Dummies Questions & Answers
Hello
I am currently having problems in mapulating a certain file which contains vaious data.
Belos is a sample content
Event=<3190>
Client IP=<151.111.11.143> DNS=<abc.sbc.com> TransCount=<139>
Client IP=<150.222.133.163> DNS=<xyz.yuu.com> TransCount=<3734>
Event=<3120>
Client... (11 Replies)
Discussion started by: khestoi
11 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I have two, double column data files (file1 and file2). I want to add the second column of file2 to as 3rd column of file1. But, the 3rd column values corresponds to the values of the 2nd column.
example:
file1:
X Y
=========
x1 y2
x3 y4
x2 y4
x5 y3
=========
file2:
Y ... (7 Replies)
Discussion started by: gaurab
7 Replies
6. UNIX for Dummies Questions & Answers
Hallo Team,
I need to manipulate existing data file. Have a look at current data and expected data:
Current Data:
27873517141
27873540000
27873515109
27873517140
27873540001
27873540000
27873501343
27873540000
27873517140
27873511292
27873645989
27873540000
27873540000... (7 Replies)
Discussion started by: kekanap
7 Replies
7. UNIX for Dummies Questions & Answers
Hallo Team,
I need your help. I would like to change field9 format to yyyy-mm-dd it should be for example 2013-11-16 instead of 20131116
0780112843,0873599381,E,ISOL,ZAR,0.0035,O,1,20131116,4373200,0.21
0733001720,0873516499,E,ISOL,ZAR,0.0035,O,1,20131116,4331600,0.21... (3 Replies)
Discussion started by: kekanap
3 Replies
8. UNIX for Dummies Questions & Answers
Dear Sir,
I have file input
RGR001|108.28|-2.86489|100-120|RANGGAR
RGR002|108.071|-2.69028|80-100|RANNGAR
RGR003|108.168|-2.97053|50-80|RANNGAR
RGR007|108.192722222|-2.766138889|0-50|RANGGARI want to create files by joining each rows with each rows below
Output as below
... (4 Replies)
Discussion started by: radius
4 Replies
9. Shell Programming and Scripting
Hallo Team,
I need your help. I have a file that has two colums. See sample below:
105550 0.28
105550 0.24
125550 0.28
125550 0.24
215650 0.28
215650 0.24
315550 0.28
315550 0.24
335550 0.28
335550 0.24
40555 0.21
40555 0.17
415550 0.21
415550 0.17
43555 0.21
43555 0.17 (5 Replies)
Discussion started by: kekanap
5 Replies
10. Shell Programming and Scripting
Hello,
I have a huge set of data that needs to be reformatted.
Here is a simple example to explain the process.
I have number n=5 and a input with many numbers separated with comma:
... (11 Replies)
Discussion started by: liuzhencc
11 Replies
LEARN ABOUT PHP
maxdb_stmt_execute
MAXDB_STMT_EXECUTE(3) 1 MAXDB_STMT_EXECUTE(3)
maxdb_stmt_execute - Executes a prepared Query
Procedural style
SYNOPSIS
bool maxdb_stmt_execute (resource $stmt)
DESCRIPTION
Object oriented style
bool maxdb_stmt::execute (void )
The maxdb_stmt_execute(3) function executes a query that has been previously prepared using the maxdb_prepare(3) function represented by
the $stmt resource. When executed any parameter markers which exist will automatically be replaced with the appropiate data.
If the statement is UPDATE, DELETE, or INSERT, the total number of affected rows can be determined by using the
maxdb_stmt_affected_rows(3) function. Likewise, if the query yields a result set the maxdb_fetch(3) function is used.
Note
When using maxdb_stmt_execute(3), the maxdb_fetch(3) function must be used to fetch the data prior to preforming any additional
queries.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Object oriented style
<?php
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
$maxdb->query("CREATE TABLE temp.mycity LIKE hotel.city");
/* Prepare an insert statement */
$query = "INSERT INTO temp.mycity (zip, name, state) VALUES (?,?,?)";
$stmt = $maxdb->prepare($query);
$stmt->bind_param("sss", $val1, $val2, $val3);
$val1 = '11111';
$val2 = 'Georgetown';
$val3 = 'NY';
/* Execute the statement */
$stmt->execute();
$val1 = '22222';
$val2 = 'Hubbatown';
$val3 = 'CA';
/* Execute the statement */
$stmt->execute();
/* close statement */
$stmt->close();
/* retrieve all rows from myCity */
$query = "SELECT zip, name, state FROM temp.mycity";
if ($result = $maxdb->query($query)) {
while ($row = $result->fetch_row()) {
printf("%s (%s,%s)
", $row[0], $row[1], $row[2]);
}
/* free result set */
$result->close();
}
/* remove table */
$maxdb->query("DROP TABLE temp.mycity");
/* close connection */
$maxdb->close();
?>
Example #2
Procedural style
<?php
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
maxdb_query($link, "CREATE TABLE temp.mycity LIKE hotel.city");
/* Prepare an insert statement */
$query = "INSERT INTO temp.mycity (zip, name, state) VALUES (?,?,?)";
$stmt = maxdb_prepare($link, $query);
maxdb_stmt_bind_param($stmt, "sss", $val1, $val2, $val3);
$val1 = '11111';
$val2 = 'Georgetown';
$val3 = 'NY';
/* Execute the statement */
maxdb_stmt_execute($stmt);
$val1 = '22222';
$val2 = 'Hubbatown';
$val3 = 'CA';
/* Execute the statement */
maxdb_stmt_execute($stmt);
/* close statement */
maxdb_stmt_close($stmt);
/* retrieve all rows from myCity */
$query = "SELECT zip, name, state FROM temp.mycity";
if ($result = maxdb_query($link, $query)) {
while ($row = maxdb_fetch_row($result)) {
printf("%s (%s,%s)
", $row[0], $row[1], $row[2]);
}
/* free result set */
maxdb_free_result($result);
}
/* remove table */
maxdb_query($link, "DROP TABLE temp.mycity");
/* close connection */
maxdb_close($link);
?>
The above example will output something similar to:
11111 (Georgetown,NY)
22222 (Hubbatown,CA)
SEE ALSO
maxdb_prepare(3), maxdb_stmt_bind_param(3).
PHP Documentation Group MAXDB_STMT_EXECUTE(3)