Variable definition inside mysql query Post: 303034945

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 303034945 by baris35 on Thursday 9th of May 2019 04:34:39 PM

Old

05-09-2019

Registered User

Hello Rudic,
Without testing, I can say that it will not return any result because there should be http://% like this:
url = 'http://%Mr.Smith.Goes.to.Washington%.mkv';
Maybe I am wrong..

If the last occupied row id is 100, I run it like this:
barisprep

Code:

CNT=100
{print  "INSERT INTO video_series_files (id, video_id, file_type, protocol, url, languages, \
quality, accessed ,status )"
        " SELECT '." ++CNT ".', video_id, 'sub', 'custom', \
'http://localhost/test/" $1 "." $2 "." $3 "', 'a:1:{i:0;s:2:\"" $2 "\";}', '', '1', '1' \
FROM video_series_files WHERE url = 'http://localhost/" $1 ".mkv';"}

Then I run:

Code:

awk -vCNT=$counter -fbarisprep 2 > barisprep.sql

Next:

Code:

grep -A0 "INSERT" barisprep.sql > 1.sql
sed -i '/--/d' 1.sql
cat 1.sql |  awk '/101/{count++; { sub("101",count+100, $0)}; }; {print }' > barisprep.sql
mysql -uroot -D mydatabase -pmypasswd -sN  < barisprep.sql

Thank you
Boris

Last edited by baris35; 05-09-2019 at 05:41 PM.. Reason: extra info added

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

replace

replace(1)							  MySQL database							replace(1)

NAME

       replace	-  A utility program that is used by msql2mysql, but that has more general applicability as well. replace changes strings in place
       in files or on the standard input. Uses a finite state machine to match longer strings first. Can be used to swap strings.

USAGE

       replace [-?svIV] from to from to ... -- [files]

       or

       replace [-?svIV] from to from to ... < fromfile > tofile

SYNOPSIS

       replace [-?|-I] [-s] [-v]

DESCRIPTION

       replace

       -?|-I  info

       -s     silent

       -v     verbose

EXTRA INFO

       Special characters in from string:

       ^     Match start of line.

       $     Match end of line.

            Match space-character, start of line or end of line. For a end  the next replace starts locking at the end space-character.  A	
	      alone in a string matches only a space-character.

EXAMPLE

       this command swaps a and b in the given files:

       shell> replace a b b a -- file1 file2 ...

SEE ALSO

       isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privi-
       lege_tables(1), mysqlshow(1), mysql_zap(1), perror(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							replace(1)