Variable definition inside mysql query Post: 303034931

Login or Register to Ask a Question and Join Our Community

Sponsored Content

Top Forums UNIX for Beginners Questions & Answers Variable definition inside mysql query Post 303034931 by baris35 on Thursday 9th of May 2019 11:46:01 AM

Old

05-09-2019

Registered User

I think I've found the root cause.
When I was about to post this thread, I supposed that the code was not grabbing video_id from related line as I received error. Now I see I have to change the lasting part of the code :

Code:

....WHERE url like '%" $1 "%.mkv';"}

like

Code:

....WHERE url like '" $1 "%.mkv';"}

or:

Code:

....WHERE url like '" $1 ".mkv';"}

Let's say: if $1 is It, the code finds many matching lines in '%It%.mkv'
If the value in $1 is This.is.how.we.do.it.mkv, it returns with error as there are double entries.

I will post the result later on as my database needs to be repaired.

Thank you
Boris

baris35

View Public Profile for baris35

Find all posts by baris35

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

What wrong with the variable definition

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:

2. Shell Programming and Scripting

Passing a variable from shell script to mysql query?

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. ...

3. Shell Programming and Scripting

variable inside variable inside loop headache

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...

4. Shell Programming and Scripting

How to define a variable with variable definition is stored in a variable?

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...

5. Shell Programming and Scripting

bash assign mysql query single field to variable

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...

6. Shell Programming and Scripting

Using a shell script variable in a mysql query using 'LIKE'

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...

7. UNIX for Dummies Questions & Answers

What is inside the definition of Unix?

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 ...

8. UNIX for Advanced & Expert Users

Variable definition

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....

9. UNIX for Dummies Questions & Answers

Environment variable definition

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...

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)