I am performing some operation like:
SQL Statement below:
UPDATE table2 SET column1_table2 = ( SELECT column1_table1
FROM table1 WHERE column2_table1 = column2_table2 LIMIT 1)
LIMIT 2;
So what I'm trying to do is to find a corresponding value and then I'm adding it into table2. Now how... (2 Replies)
I have a very big file of 5gb size and there are about 50 million records in there. I have to delete the records based on recrord number that I know fromoutside with out opening the file. The record numbers are very random like 5000678, 7890005 etc.
Can somebody let me know how i can... (5 Replies)
Function: int fcntl(int fd, int cmd, struct flock * lock)
Data Type: struct flock
This structure is used with the fcntl function to describe a file lock. It has these members:
off_t l_start
This specifies the offset of the start of the region to which the lock applies, and... (1 Reply)
Hello. I just found out about awk, and it appears that this could handle the problem I'm having right now.
I first stumbled on the thread How to extract first and last line of different record from a file, and that problem is almost similar to mine.
In my case, an ASCII file will contain the... (0 Replies)
Hi,
I need to come up with a site that will display all the records in the database, but one at a time.
Not sure how to go about it.
Please pour in your suggestions.
Thanks
---------- Post updated at 04:38 AM ---------- Previous update was at 12:52 AM ----------
Can... (3 Replies)
How do i find the record which has been edit the last 10 minutes?
from a.txt which has last field is epoch time updated.
10/17/2012 1:47 PM||||||In Use|chicken||1350005487
10/17/2012 2:53 PM||||||Available|chicken||13500000
10/17/2012 3:20 PM||||||In Use|cat||1351000000
10/17/2012 3:22... (2 Replies)
Hi,
I am trying to get the position of a repeated string in a line using
grep -b -o "pattern"
In my server I am using GNU grep version 2.14 and the code is working fine. However when I am deploying the same code in a different server which is using GNU grep version 2.5.1 the code is not... (3 Replies)
Dear all,
I want to offset the file numbers. can you please make some awk code or linux code for the same.
Example:
input file names
ANI_WFMASS_PIST00001.gif
ANI_WFMASS_PIST00002.gif
.
.
.
ANI_WFMASS_PIST0000n.gif
offset --> 30
ANI_WFMASS_PIST00031.gif
ANI_WFMASS_PIST00032.gif... (14 Replies)
Hi Team,
Is there a way to grep time taken to save records.
Its like there is one webpage where when I click save button taking so much time to save result.
Therefore, I want to grep that time taken to save that record from file.log
Thanks in advance. (1 Reply)
Input File:
E 3359799 3360148 350 X
D 3471287 3471607 321 X
E 3359799 3360740 942 X
E 4359790 4360039 250 X
.
.
.
Desired Output File:
E 3359799 3359998 200 X
E 3359999 3360148 150 X
D 3471287 3471486 200 X
D 3471487 3471607 121 X
E 3359799 3359998 200 X
E 3359999 3360198 200 X... (1 Reply)
Discussion started by: perl_beginner
1 Replies
LEARN ABOUT DEBIAN
gpscorrelate
GPSCORRELATE(1) [FIXME: manual] GPSCORRELATE(1)NAME
gpscorrelate - correlates digital images with GPS data filling EXIF fields
SYNOPSIS
gpscorrelate [-z | --timeadd +/-HH[:MM]] [-O | --photooffset seconds] [-i | --no-interpolation] [-v | --verbose] [-d | --datum datum] [-n |
--no-write] [-m | --max-dist time] [-t | --ignore-tracksegs] [-M | --no-mtime] [-f | --fix-timestamps] [-p | --degmins]
-g file.gpx image.jpg...
gpscorrelate -s | --show | -o | --machine image.jpg...
gpscorrelate [-M | --no-mtime] {-r | --remove} image.jpg...
gpscorrelate -V | --version | -h | --help
gpscorrelate-gui
DESCRIPTION
This manual page documents briefly the gpscorrelate and gpscorrelate-gui commands.
There is an extended documenation available in HTML format; see below.
gpscorrelate is a program that acts on digital images in JPEG format filling EXIF (Exchangeable Image File Format) fields related to GPS
(Global Positioning System) information. Source for the GPS data is a record of GPS information encoded in GPX (GPS Exchange Format)
Format. The act of filling those fields is referred to as correlation.
If GPS data are available at the precise moment the image was taken (with a 1-second granularity) the GPS data are stored unmodified in
EXIF fields. If they are not linear interpolation of GPS data available at moments before and after the image was taken can be used.
gpscorrelate is a command line tool implementing correlation whereas gpscorrelate-gui is the corresponding GTK+ graphical user interface.
OPTIONS
These programs follow the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of options is included
below. For a complete description, see the HTML documentation.
-g, --gps file.gpx
correlate using the specified GPX file with GPS data
-s, --show
only show the GPS data of the given images
-o, --machine
only show the GPS data of the given images in a machine readable output, if there is any
-r, --remove
only remove GPS EXIF data from the given images
-z, --timeadd +/-XX[:XX]
time to add to GPS data to make it match the timestamps of the images. GPS data is in UTC; images are not likely to be in UTC. Enter
the timezone used when taking the images: eg, +8 for Perth
-O, --photooffset seconds
time in seconds to add to the photo timestamp to make it match the GPS timestamp. To determine the amount of seconds needed, just
create a picture of your GPS device showing the current time and compare it with the timestamp of your photo file.
-i, --no-interpolation
disable interpolation between points. Interpolation is linear, points are rounded if disabled
-v, --verbose
show which GPS data has been selected for each image
-d, --datum datum
specify measurement datum. If not set, WGS-84 used
-n, --no-write
do not write the exif data. Useful with --verbose
-m, --max-dist time
max time outside points that image will be matched. Time is in seconds
-t, --ignore-tracksegs
Interpolate between track segments, too
-M, --no-mtime
Do not change mtime of modified files
-f, --fix-timestamps
Fix broken GPS datestamps written with versions < 1.5.2
-p, --degmins
Write location as DD MM.MM as was default before < 1.5.3
-h, --help
Only show summary of options
-V, --version
Only print the version
SEE ALSO
gpsd (1), gpsbabel (1), gpxlogger (1), cgpxlogger (1).
The documentation of gpscorrelate and gpscorrelate-gui in HTML format are available on the filesystem at /usr/share/doc/gpscorrelate.
AUTHOR
This manual page was initially written by Stefano Zacchiroli zack@debian.org for the Debian(TM) system. It was extended by Till Maas
opensource@till.name. Permission is granted to copy, distribute and/or modify this document under the terms of the GNU General Public
License, Version 2 any later version published by the Free Software Foundation.
On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.
AUTHOR
Stefano Zacchiroli
Author.
COPYRIGHT
Copyright (C) 2006, 2008 Stefano Zacchiroli zack@debian.org, Till Maas
[FIXME: source] 30 Oct 2008 GPSCORRELATE(1)