05-09-2019
The bold video_id IS the column value from the table.
Do you REALLY want the string constant '.655.' (with two enclosing dots), or the integer video ID?
What is the output of your above select, and what if '.655.' is replaced by video_id?
This User Gave Thanks to RudiC For This Post:
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i am using the below script and trying to move files in that directory in that pattern to archive. But it doesn;t seem to take the metacharacters. Please sugggest.
Code
Debug output: (1 Reply)
Discussion started by: dsravan
1 Replies
2. Shell Programming and Scripting
I heard this was possible but from my research I haven't been able to figure it out yet. Seems it should be simple enough. Basically from a high level view I'm trying to accomplish...
. $X='grep foo blah.log'
then 'mysql command SELECT foo FROM bar WHERE ' . $X
or something like that.
... (2 Replies)
Discussion started by: kero
2 Replies
3. Shell Programming and Scripting
Hi Gurus
I have a file called /tmp/CMDB which looks like this
serial: 0623AN1208
hostname: server1
model: x4100
assetID: 1234
I am writing a for loop that will go through this file line by line creating a variable of itself. Using the first iteration of the loop (i.e. the first line) as... (6 Replies)
Discussion started by: hcclnoodles
6 Replies
4. Shell Programming and Scripting
Hi all,
I have a variable say var1 (output from somewhere, which I can't change)which store something like this:
echo $var1
name=fred
age=25
address="123 abc"
password=pass1234
how can I make the variable $name, $age, $address and $password contain the info?
I mean do this in a... (1 Reply)
Discussion started by: freddy1228
1 Replies
5. Shell Programming and Scripting
I'm running a bash script query and assigning the output to a variable like this:
exists=`mysql -u $USER_NAME --password=$PASSWORD -D "somedb" \
-e "SELECT * FROM somedb.sometable WHERE field1 ='$a' \
AND field2 ='$b' LIMIT 0 , 30";`
which returns something like:
echo... (2 Replies)
Discussion started by: unclecameron
2 Replies
6. Shell Programming and Scripting
Hello. I am writing a simple script that reads a text file and removes records from a mysql database. The items in the text file are of the format:
firstname.middle.lastXXX, where XXX is a 3 digit number. The table has an email field that will match the firstname.middle.last. So, I thought I... (1 Reply)
Discussion started by: bricoleur
1 Replies
7. UNIX for Dummies Questions & Answers
Is FreeBSD and OpenBSD considered Unix? What O.S does Most of the forum members use? How popular are Licensed Unix operating systems for home users?
Additionally I thought Linux was a Minux fork and BSD was a Unix fork.
Thanks in ... (7 Replies)
Discussion started by: theKbStockpiler
7 Replies
8. UNIX for Advanced & Expert Users
Hi all,
I'm bit new to the advanced bash shell scripting.
When I'm looking at some of the existing code in my organization, got confused with a few variable definings.
For ex:
var1={1:-30}
var2="abc def ghi"
var3={xyz:-$var2}
In above, 1st and last lines are confusing me.... (4 Replies)
Discussion started by: raghu.iv85
4 Replies
9. UNIX for Dummies Questions & Answers
I'm a bit confused about the term ‘environment variables'.
Within your shell you can set two types of variables:
1. Shell variable - affecting functionality within your shell
2. User defined variable
When using the ‘export' command on a variable you make sure it's being inherited by new sub... (2 Replies)
Discussion started by: niels
2 Replies
LEARN ABOUT DEBIAN
mysql2dlf
MYSQL2DLF.IN(1) LogReport's Lire Documentation MYSQL2DLF.IN(1)
NAME
mysql2dlf - convert mysql logfiles to dlf format
SYNOPSIS
mysql2dlf
DESCRIPTION
mysql2dlf converts a MySQL query log file to DLF format. Information on MySQL can be found on http://www.mysql.org/. The query log file is
defined by the --log[=file] option of mysqld, or the log=file setting in MySQL configuration file.
Such a log file looks like e.g.
/usr/sbin/mysqld, Version: 3.23.43-debug-log, started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
011218 15:02:58 1 Connect root@localhost on
1 Query SHOW VARIABLES LIKE 'pid_file'
1 Shutdown
011226 21:35:59 6 Connect joe@localhost on
6 Init DB nmrshiftdb
6 Query SHOW VARIABLES
or
42401 Query SELECT
bannerID,
banner,
format,
width,
height,
alt,
url
FROM
banners
WHERE
act = 'true' AND (keyw = 'fullsize' OR keyw = 'global')
The generic database dlf format is described in database.xml.
EXAMPLES
To process a log as produced by MySQL:
$ mysql2dlf < mysql-log
mysql2dlf will be rarely used on its own, but is more likely called by lr_log2report:
$ lr_log2report mysql < /var/log/mysql-log
NOTES
The parser has been tested for query log files for MySQL 3.23.46 only.
BUGS
This converter stores all log files information in one big nested array in memory, before writing. Therefore, memory consumption is linear
with the size of the log.
SEE ALSO
mysql(1), mysqld(1)
VERSION
$Id: mysql2dlf.in,v 1.12 2010/12/05 20:36:45 wraay Exp $
COPYRIGHT
Copyright (C) 2001, 2002 Stichting LogReport Foundation LogReport@LogReport.org
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program (see COPYING); if not, check with
http://www.gnu.org/copyleft/gpl.html.
AUTHOR
Egon Willighagen <egonw@logreport.org>
Lire 2.1.1 2011-12-31 MYSQL2DLF.IN(1)