Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Variable definition inside mysql query
Top Forums UNIX for Beginners Questions & Answers Variable definition inside mysql query Post 303034904 by baris35 on Thursday 9th of May 2019 09:15:11 AM
Old 05-09-2019
Variable definition inside mysql query
Hello,
I am running ubuntu16.04.
By means of @Rudic's help, I have below command.
What I need to do is to replace video_id by value of video_id in which WHERE clause is matched:

Code:
{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 like '%" $1 "%.mkv';"}

video_id is the name of column, video_id should be the value inside the same row when "WHERE" query matches.

I assigned variable as @video_id and then tried to grab the value_id but no luck :
Code:
{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 like '%" $1 "%.mkv' \
AND SET @video_id=video_id IN (SELECT video_id FROM video_series_files \
WHERE url like '%$COL1%.mkv') ;" }

I'd appreciate your help
Thank you
Boris
 

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: (1 Reply)
Discussion started by: dsravan
1 Replies

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. ... (2 Replies)
Discussion started by: kero
2 Replies

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... (6 Replies)
Discussion started by: hcclnoodles
6 Replies

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... (1 Reply)
Discussion started by: freddy1228
1 Replies

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... (2 Replies)
Discussion started by: unclecameron
2 Replies

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... (1 Reply)
Discussion started by: bricoleur
1 Replies

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 ... (7 Replies)
Discussion started by: theKbStockpiler
7 Replies

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.... (4 Replies)
Discussion started by: raghu.iv85
4 Replies

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... (2 Replies)
Discussion started by: niels
2 Replies

LEARN ABOUT DEBIAN

webservice::youtube::videos

WebService::YouTube::Videos(3pm)			User Contributed Perl Documentation			  WebService::YouTube::Videos(3pm)

NAME

       WebService::YouTube::Videos - Perl interface to youtube.videos.*

VERSION

       This document describes WebService::YouTube::Videos version 1.0.3

SYNOPSIS

	   use WebService::YouTube::Videos;

	   my $api = WebService::YouTube::Videos->new( { dev_id => YOUR_DEV_ID } );

	   # Call API youtube.videos.list_featured
	   my @videos = $api->list_featured;
	   foreach my $video (@videos) {
	       # $video->isa('WebService::YouTube::Video');
	   }

	   # Call other APIs
	   my @videos = $api->list_by_user($user);
	   my @videos = $api->list_by_tag($tag);

	   my $video = $api->get_details($video_id);

	   # Parse XML
	   my @video = $api->parse_xml($xml);	 # when $xml contains <video_list>
	   my $video = $api->parse_xml($xml);	 # when $xml contains <video_details>

DESCRIPTION

       This is a Perl interface to YouTube REST API.

       See Developer APIs <http://youtube.com/dev> and Developer API -- REST Interface <http://youtube.com/dev_rest> for details.

SUBROUTINES
/METHODS
   new(\%fields)
       Creates and returns a new WebService::YouTube::Videos object.  %fields can contain parameters enumerated in "ACCESSORS" section.

   parse_xml($xml)
       Parses XML and returns the result.  $xml should be an object that XML::Simple can understand.

   get_details( $video_id )
       Returns a WebService::YouTube::Video object.  $video_id is an ID of the video which you want to get details.

       See <http://youtube.com/dev_api_ref?m=youtube.videos.get_details> for details.

   list_by_tag( $tag, \%fields )
       Returns an array of WebService::YouTube::Video object.  $tag is a keyword string separated by a space.  %fields can contain the optional
       parameters.

       page
	   1 <= page

       per_page
	   per_page <= 100 (default 20)

       See <http://youtube.com/dev_api_ref?m=youtube.videos.list_by_tag> for details.

   list_by_user( $user )
       Returns an array of WebService::YouTube::Video object.  $tag is a keyword string separated by a space.  %fields can contain optional
       parameters.

       See <http://youtube.com/dev_api_ref?m=youtube.videos.list_by_user> for details.

   list_featured( )
       Returns an array of WebService::YouTube::Video object.

       See <http://youtube.com/dev_api_ref?m=youtube.videos.list_featured> for details.

   ACCESSORS
       dev_id

       Developer ID

       ua

       LWP::UserAgent object

DIAGNOSTICS

       dev_id is required
	   Developer ID is required when you call API of YouTube.

       invalid XML
	   The XML is not a YouTube's XML.

       unknown response
	   The ut_response is neither <video_list> nor <video_details>.

CONFIGURATION AND ENVIRONMENT

       WebService::YouTube::Videos requires no configuration files or environment variables.

DEPENDENCIES

       Class::Accessor::Fast, LWP::UserAgent, XML::Simple, WebService::YouTube::Util, WebService::YouTube::Video

INCOMPATIBILITIES

       None reported.

BUGS AND LIMITATIONS

       No bugs have been reported.

       Please report any bugs or feature requests to "bug-webservice-youtube@rt.cpan.org", or through the web interface at
       <http://rt.cpan.org/NoAuth/ReportBug.html?Queue=WebService-YouTube>.  I will be notified, and then you'll automatically be notified of
       progress on your bug as I make changes.

AUTHOR

       Hironori Yoshida <yoshida@cpan.org>

LICENSE AND COPYRIGHT

       This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See perlartistic.

perl v5.10.1							    2010-08-01					  WebService::YouTube::Videos(3pm)
All times are GMT -4. The time now is 03:46 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy