Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Variable definition inside mysql query Post 303034908 by wassi on Thursday 9th of May 2019 09:30:32 AM
Old 05-09-2019
replace means update not insert ???
 

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
nl-qdisc(8)						      System Manager's Manual						       nl-qdisc(8)

NAME
nl-qdisc-{add|list|delete} - Manage queueing disciplines SYNOPSIS
nl-qdisc-add --dev dev --parent id [OPTIONS] qdisc-type [QDISC] nl-qdisc-delete [ --interactive ] [OPTIONS] nl-qdisc-list [OPTIONS] DESCRIPTION
The nl-qdisc tools allow to manage and configure queueing disciplines (qdiscs) in the kernel. OPTIONS
-h or --help Print help text to console and exit. -v or --version Print versioning information to console and exit. -q or --quiet Do not print informal notifications about actions taken to the console. By default a short description of each qdisc added/update/deleted will be printed to the console. This option disables this behaviour. -d or --dev=DEV Network device the qdisc is attached to. -p or --parent=ID Identifier of the parent qdisc/class this qdisc is attached to. The identifier can be specified as classid, name or one of the spe- cial values "root" or "ingress". -i or --id=ID Identifier of qdisc. It can be specified as classid or name. nl-qdisc-add Options --update Update qdisc if it already exists, otherwise attempting to add a qdisc which already exists will result in an error. This does not include changing the type of the qdisc, use --replace if you wish to do so. --replace Replace or update qdisc if it already exists. Same behaviour as --update but will completely replace the qdisc if it exists already. --update-only Update an existing qdisc but do not create it if it does not exist. --replace-only Update or replace an existing qdisc but do not create it if it does exist. nl-qdisc-delete Options --interactive The interactive mode requires confirmation by the user for each qdisc deleted. It will print a prompt for each qdisc matching the provided filter and requires the user to answer 'y'es or 'n'o. --yes Make the default answer for interactive prompts be 'y'es. This option is also required to delete all qdiscs on all network devices. -k or --kind=TYPE Only delete qdiscs of this type. nl-qdisc-list Options --details Show detailed information for each qdisc listed. --stats Show statistics information for each qdisc listed. This option will also turn on detailed information automatically. -r or --recursive List all TC objects recurisvely attached to all qdiscs matching the filter. -k or --kind=TYPE Only list qdiscs of this type. USAGE
Add a HTB root qdisc with id "5:": nl-qdisc-add --dev eth0 --parent root --id 5: htb List all qdiscs on eth0 and print statistical data: nl-qdisc-list --stats --dev eth0 Delete the qdisc "5:": nl-qdisc-delete --id 5: SEE ALSO
nl-classid-lookup(8) AUTHOR
Thomas Graf is the original author and current maintainer of libnl and libnl tools. Many people have contributed to it since. libnl 21 October 2010 nl-qdisc(8)
All times are GMT -4. The time now is 10:15 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy