11-01-2019
Data?
Your indices don't seem to be consistent.
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Thought i should start this has a new thread.
i am stuck on the following question, but after learning more unix, i have written an answer to it. Can anyone check to see if it is correct and what improvements need to be made?
Question:
Write a pipeline that updates the content of a file (a... (0 Replies)
Discussion started by: Vn3050
0 Replies
2. Shell Programming and Scripting
Hi ,
I have file :
after i run this command :
there are error
can we print blank line if output error ??
thanks.. ^^ (4 Replies)
Discussion started by: justbow
4 Replies
3. Shell Programming and Scripting
Hi,
I'm executing unixbench tool v4.1 on an embedded system and I'm getting these error messages:
Execl Throughput 1 2 3awk: /unixbench/unixbench-4.1.0/pgms/loops.awk:38: (FILENAME=- FNR=4) fatal: division by zero attempted
Pipe Throughput 1 2 3 4 5 6 7 8 9 10awk:... (3 Replies)
Discussion started by: rogelio
3 Replies
4. Shell Programming and Scripting
Hello,
I am searching for a way to calculate for example 10/100 within a shellscript and the result should be 0.1 and not just 0.
Every alternative i tried just results 0
Thank you in advance
2retti (6 Replies)
Discussion started by: 2retti
6 Replies
5. UNIX for Dummies Questions & Answers
hi,
The below commands result only the whole number(not giving the decimal values).
pandeeswaran@ubuntu:~$ echo 1,2,3,4|sed 's/,/\//g'|bc
0
pandeeswaran@ubuntu:~$ echo 1000,2,3|sed 's/,/\//g'|bc
166
How to make it to return the decimal values?
Thanks (5 Replies)
Discussion started by: pandeesh
5 Replies
6. Shell Programming and Scripting
when i try the snippet in the console its working fine:
ps awwwux | grep php-fpm | grep -v grep | grep -v master | awk '{total_mem = $6 * 1024 + total_mem; total_proc++} END{printf("%d\n", total_mem / total_proc)}'
output:
but when i try the bash script:
#!/bin/sh
# -*- sh -*-
#... (3 Replies)
Discussion started by: danieloooo
3 Replies
7. Shell Programming and Scripting
Hi Friends,
My input
chr1 100 200 1234E-02 0.01 0.05 10
chr1 100 200 14E-11 0.11 0.50 1
chr1 100 200 134E-22 0.00 0.65 111
My command
awk '{print $1"\t"$2"\t"$3"\t"$4"\t"$5"\t"$6"\t"$13}' input | awk '{v=($5/$6); print $0"\t"v}' OFS="\t" | awk '{$8=(log($8)/log(2)); print $0}'... (4 Replies)
Discussion started by: jacobs.smith
4 Replies
8. Shell Programming and Scripting
I want to implement the below formula with awk oneliner
new_value = ((old_value - old_min) / (old_max - old_min) ) * (new_max - new_min) + new_min
I want to pass the value of old_min and old_min as variable. Here is what I did for this
old_min=$(awk 'BEGIN{a=100000000000}{if ($10<0+a) a=$10}... (2 Replies)
Discussion started by: sammy777888
2 Replies
9. What is on Your Mind?
Today, I noticed some errors in our SSL cert renewal log files, mostly related to domains where the IP address had changed. Concerned about this, rebuilt out SSL cert, which normally goes well without a hiccup.
However, for today, for some reason which I cannot explain, there was a PHP error... (0 Replies)
Discussion started by: Neo
0 Replies
LEARN ABOUT PHP
sqlite_unbuffered_query
SQLITE_UNBUFFERED_QUERY(3) SQLITE_UNBUFFERED_QUERY(3)
sqlite_unbuffered_query - Execute a query that does not prefetch and buffer all data
SYNOPSIS
resource sqlite_unbuffered_query (resource $dbhandle, string $query, [int $result_type = SQLITE_BOTH], [string &$error_msg])
DESCRIPTION
resource sqlite_unbuffered_query (string $query, resource $dbhandle, [int $result_type = SQLITE_BOTH], [string &$error_msg])
Object oriented style (method): SQLiteUnbuffered SQLiteDatabase::unbufferedQuery (string $query, [int $result_type = SQLITE_BOTH],
[string &$error_msg])
sqlite_unbuffered_query(3) is identical to sqlite_query(3) except that the result that is returned is a sequential forward-only result set
that can only be used to read each row, one after the other.
This function is ideal for generating things such as HTML tables where you only need to process one row at a time and don't need to ran-
domly access the row data.
Note
Functions such as sqlite_seek(3), sqlite_rewind(3), sqlite_next(3), sqlite_current(3), and sqlite_num_rows(3) do not work on result
handles returned from sqlite_unbuffered_query(3).
PARAMETERS
o $dbhandle
- The SQLite Database resource; returned from sqlite_open(3) when used procedurally. This parameter is not required when using the
object-oriented method.
o $query
- The query to be executed. Data inside the query should be properly escaped.
o $result_type
-The optional $result_type parameter accepts a constant and determines how the returned array will be indexed. Using SQLITE_ASSOC
will return only associative indices (named fields) while SQLITE_NUM will return only numerical indices (ordinal field numbers).
SQLITE_BOTH will return both associative and numerical indices. SQLITE_BOTH is the default for this function.
o $error_msg
- The specified variable will be filled if an error occurs. This is specially important because SQL syntax errors can't be fetched
using the sqlite_last_error(3) function.
Note
Two alternative syntaxes are supported for compatibility with other database extensions (such as MySQL). The preferred form is the
first, where the $dbhandle parameter is the first parameter to the function.
RETURN VALUES
Returns a result handle or FALSE on failure.
sqlite_unbuffered_query(3) returns a sequential forward-only result set that can only be used to read each row, one after the other.
CHANGELOG
+--------+---------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------+
| 5.1.0 | |
| | |
| | Added the $error_msg parameter |
| | |
+--------+---------------------------------+
SEE ALSO
sqlite_query(3).
PHP Documentation Group SQLITE_UNBUFFERED_QUERY(3)