Variable definition inside mysql query Post: 303034925

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 303034925 by RudiC on Thursday 9th of May 2019 11:17:53 AM

Old

05-09-2019

Registered User

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:

RudiC

View Public Profile for RudiC

Find all posts by RudiC

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

alifmt

ALIFMT(5)							   User Manuals 							 ALIFMT(5)

NAME

       alifmt - Aligned sequences formats

DESCRIPTION

       This document illustrates some common formats used for aligned sequences representation.

       CLUSTAL
	    CLUSTAL W (1.82) multiple sequence alignment

	    MALK_ECOLI	    MASVQLQNVTKAWGEVVVSKDINLDIHEGEFVVFVGPSGCGKSTL
	    MALK_SALTY	    MASVQLRNVTKAWGDVVVSKDINLDIHDGEFVVFVGPSGCGKSTL
	    MALK_ENTAE	    MASVQLRNVTKAWGDVVVSKDINLEIQDGEFVVFVGPSGCGKSTL
	    MALK_PHOLU	    MSSVTLRNVSKAYGETIISKNINLEIQEGEF--------------
			    *:** *:**:**:*:.::**:***:*::***

	    MALK_ECOLI	    LRMIAGLETITSGDLACRRLHKEPGV
	    MALK_SALTY	    LRMIAGLETITSGDLACRRLHQEPGV
	    MALK_ENTAE	    LRMIAGLETVTSGDL-----------
	    MALK_PHOLU	    LRM-----------------------
			    ***

	   Warning: Names must not contain spaces or exceed 30 characters.

       FASTA
	    >MALK_ECOLI
	    MASVQLQNVTKAWGEVVVSKDINLDIHEGEFVVFVGPSGCGKSTLLRMIA
	    GLETITSGDLACRRLHKEPGV
	    >MALK_SALTY
	    MASVQLRNVTKAWGDVVVSKDINLDIHDGEFVVFVGPSGCGKSTLLRMIA
	    GLETITSGDLACRRLHQEPGV
	    >MALK_ENTAE
	    MASVQLRNVTKAWGDVVVSKDINLEIQDGEFVVFVGPSGCGKSTLLRMIA
	    GLETVTSGDL-----------
	    >MALK_PHOLU
	    MSSVTLRNVSKAYGETIISKNINLEIQEGEF--------------LRM--
	    ---------------------

       MEGA
	    #mega
	    !Title Multiple Sequence Alignment;

	    #MALK_ECOLI
	    MASVQLQNVTKAWGEVVVSKDINLDIHEGEFVVFVGPSGCGKSTLLRMIA
	    GLETITSGDLACRRLHKEPGV
	    #MALK_SALTY
	    MASVQLRNVTKAWGDVVVSKDINLDIHDGEFVVFVGPSGCGKSTLLRMIA
	    GLETITSGDLACRRLHQEPGV
	    #MALK_ENTAE
	    MASVQLRNVTKAWGDVVVSKDINLEIQDGEFVVFVGPSGCGKSTLLRMIA
	    GLETVTSGDL-----------
	    #MALK_PHOLU
	    MSSVTLRNVSKAYGETIISKNINLEIQEGEF-------------------
	    ---------------------

       MSF
	    !!AA_MULTIPLE_ALIGNMENT 1.0
	    PileUp of: @pep.list

	     msf.seq	   MSF: 55  Type: P  Nov 22, 2001 11:02  Check: 2529 ..

	     Name: m73237	    Len:   655	Check: 7493  Weight:  1.00
	     Name: l28824	    Len:   655	Check: 5456  Weight:  1.00
	     Name: u04379	    Len:   655	Check: 9580  Weight:  1.00

	    //

		    1							50
	    m73237  ~~~~~MADSA NHLPFFFGQI TREEAEDYLV QGGMSDGLYL LRQSRNYLGG
	    l28824  MASSGMADSA NHLPFFFGNI TREEAEDYLV QGGMSDGLYL LRQSRNYLGG
	    u04379  ~~~~~MPDPA AHLPFFYGSI SRAEAEEHLK LAGMADGLFL LRQCLRSLGG

		    51
	    m73237  ~~~~~
	    l28824  ~~~~~
	    u04379  AACG*

	   Warning: This format cannot handle more than 500 sequences in a single alignment.

       NEXUS
	    #NEXUS

	    begin data;
	      dimensions ntax=2 nchar=89;
	      format datatype=Protein interleave gap=- missing='.';
	      matrix
	    [		1						50]
	    btdDm	-------AQQQQHHLHMQQAQHH-----------LHLSH------QQAQQ
	    TSp1	--------------------AEH-----------PSLR--------GTPL

	    [		51			    80]
	    btdDm	YACPICSKKFSRSDHLSKHKKTHF------
	    TSp1	FACPICNKRFMRSDHLAKHVKTHN------

		;
	    endblock;

	   Warning: Text enclosed in brackets is considered as comment, and thus ignored.

       PHYLIP
	   Sequential (PHYLIPS):

		 2   109
	    ATISA1    GSPNLYQ-GGRKPWHSINFICAHDGFTLADLVTYNNKNNLANGEENNDG
		      ENHNYSWNCGEEGDFASISVKRLRKRQMRNFFVSLMVSQGVPMIYMGDE
		      YGHTKGGN---
	    POTISA1   GSPNLYQKGGRKPWNSINFVCAHDGFTLADLVTYNNKHNLANGEDNKDG
		      ENHNNSWNCGEEGEFASIFVKKLRKRQMRNFFLCLMVSQGVPMIYMGDE
		      YGHTKGGN---

	   Interleaved (PHYLIPI):

		 2   109
	    ATISA1    GSPNLYQ-GGRKPWHSINFICAHDGFTLADLVTYNNKNNLANGEENND
	    POTISA1   GSPNLYQKGGRKPWNSINFVCAHDGFTLADLVTYNNKHNLANGEDNKD

		      GENHNYSWNCGEEGDFASISVKRLRKRQMRNFFVSLMVSQGVPMIYMG
		      GENHNNSWNCGEEGEFASIFVKKLRKRQMRNFFLCLMVSQGVPMIYMG

		      DEYGHTKGGN---
		      DEYGHTKGGN---

	   Warning: Species names may not contain characters `( ) : ; , [ ]' and exceed 10 characters.

       STOCKHOLM
	    # STOCKHOLM 1.0

	    MALK_ECOLI	MASVQLQNVTKAWGEVVVSKDINLDIHEGEFVVFVGPSGCGKSTLLRMIA
	    MALK_SALTY	MASVQLRNVTKAWGDVVVSKDINLDIHDGEFVVFVGPSGCGKSTLLRMIA
	    MALK_ENTAE	MASVQLRNVTKAWGDVVVSKDINLEIQDGEFVVFVGPSGCGKSTLLRMIA
	    MALK_PHOLU	MSSVTLRNVSKAYGETIISKNINLEIQEGEF-------------------

	    MALK_ECOLI	RCHLFREDGTACRRLHKEPGV
	    MALK_SALTY	RCHLFREDGSACRRLHQEPGV
	    MALK_ENTAE	---------------------
	    MALK_PHOLU	---------------------
	    //

SEE ALSO

       squizz(1), seqfmt(5)

AUTHOR

       Nicolas Joly (njoly@pasteur.fr), Institut Pasteur.

Unix								    2009-05-19								 ALIFMT(5)