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 OPENSOLARIS

mysqld_multi

mysqld_multi(1) 						  MySQL database						   mysqld_multi(1)

NAME

       mysqld_multi  - is meant for managing several mysqld processes running in different UNIX sockets and TCP/IP ports.

USAGE

       mysqld_multi [OPTIONS] {start|stop|report} [GNR,GNR,GNR...]

SYNOPSIS

       mysqld_multi  [--config-file=...]   [--example]	[--help]  [--log=...]	[--mysqladmin=...]   [--mysqld=...]   [--no-log]  [--password=...]
       [--tcp-ip] [--user=...]	[--version]

DESCRIPTION

       mysqld_multi

       --config-file=...
	      Alternative config file. NOTE: This will not affect this program's own options (group [mysqld_multi]), but  only	groups	[mysqld#].
	      Without this option everything will be searched from the ordinary my.cnf file.

       --example
	      Give an example of a config file.

       --help Print this help and exit.

       --log=...
	      Log file. Full path to and the name for the log file. NOTE: If the file exists, everything will be appended.

       --mysqladmin=...
	      mysqladmin binary to be used for a server shutdown.

       --mysqld=...
	      mysqld  binary  to be used. Note that you can give mysqld_safe to this option also. The options are passed to mysqld. Just make sure
	      you have mysqld in your environment variable PATH or fix mysqld_safe.

       --no-log
	      Print to stdout instead of the log file. By default the log file is turned on.

       --password=...
	      Password for user for mysqladmin.

       --tcp-ip
	      Connect to the MySQL server(s) via the TCP/IP port instead of the UNIX socket. This affects stopping and reporting. If a socket file
	      is  missing,  the  server  may still be running, but can be accessed only via the TCP/IP port. By default connecting is done via the
	      UNIX socket.

       --user=...
	      MySQL user for mysqladmin.

       --version
	      Print the version number and exit.

NOTE

       Please see the mysql manual for more detailed information on this.

SEE ALSO

       isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1),  mysqld_safe(1),  mysqldump(1),  mysql_fix_privilege_tables(1),
       mysqlshow(1), mysql_zap(1), perror(1), replace(1)

       For  more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online
       at http://www.mysql.com/doc/en/

BUGS

       Please refer to http://bugs.mysql.com/ to report bugs.

AUTHOR

       Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/).  This  software  comes  with	no
       warranty.   Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercur-
       media.com)

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +--------------------+------------------------------------+
       |  ATTRIBUTE TYPE    |	       ATTRIBUTE VALUE		 |
       +--------------------+------------------------------------+
       |Availability	    | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
       +--------------------+------------------------------------+
       |Interface Stability | External				 |
       +--------------------+------------------------------------+
NOTES

       Source for mysql is available on http://opensolaris.org.

MySQL 4.0							 19 December 2000						   mysqld_multi(1)