calling mysql gurus : need help with my view Post: 302350077

Sponsored Content

Top Forums Shell Programming and Scripting calling mysql gurus : need help with my view Post 302350077 by hcclnoodles on Wednesday 2nd of September 2009 06:17:31 PM

09-02-2009

Registered User

calling mysql gurus : need help with my view

hi there

I have a view which is working fine, but i have been told that i need to make sure the resulting output excludes all rows with nic_status equal to the string "removed".

Does anybody know in which part of the code below i would place the conditional ...

Code:

WHERE nic_status != 'removed'

view code below

Code:

CREATE VIEW `view2` AS 
select 
`t2`.`serial` AS `serial`,
`t2`.`nic_name` AS `nic_name`,
`t2`.`nic_ip` AS `nic_ip`,
`t2`.`nic_duplex` AS `nic_duplex`,
`t2`.`nic_speed` AS `nic_speed`,
`t2`.`nic_status` AS `nic_status`,
`t2`.`datetimestamp` AS `datetimestamp` 
from `network` `t2` 
where (`t2`.`serial`,`t2`.`nic_name`,`t2`.`datetimestamp`) in
(select `network`.`serial` AS `serial`,`network`.`nic_name` AS `nic_name`,max(`network`.`datetimestamp`) AS `MAX(datetimestamp)` 
from `network` where ((`network`.`serial` = `t2`.`serial`) and (`network`.`nic_name` = `t2`.`nic_name`)) group by `network`.`serial`,`network`.`nic_name`) 
order by `t2`.`serial`,`t2`.`nic_name`;

any help on this would be great

Last edited by hcclnoodles; 09-02-2009 at 07:35 PM..

hcclnoodles

View Public Profile for hcclnoodles

Find all posts by hcclnoodles

9 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Any RF unix gurus out there?

I am having a problem here. We are having several problems in regards to hung process's on unix (HPUX box), caused by my RF equipment (Mobile data capture units). these contact the host via a simply telnet session and locks the system? Is it a timeout problem as the timeout is disabled on the host.

2. Shell Programming and Scripting

Help with shell script - Unix Gurus calling

Unix Gurus, I have been breaking my head to get this done..seems simple.. I need to read a flat file and based on a key word in a line, i need to skip the previous 3 lines. eg : Line1 Line2 Line3 Line4 Line5 Line6 Error Line7 Line8 Line9 Error Line10

3. Shell Programming and Scripting

SED GURUS - Help!

I wish to substituite a string on each line but ONLY if it appears within double-quotes: this_string="abc#def#geh" # Comment here I wish to change the "#" characters within the double quoted string to "_": this_string="abc_def_geh" # Comment here ... but as you see, the "comment" hash...

4. Shell Programming and Scripting

Calling MYSQL Stored Procedure?

Hi, Can anyone help me with the correct syntax to call a MYSQL stored procedure from a shell script. I have tried the following, (no input params): /usr/bin/mysql -uadmin -ppassword call TL_CLENSEDATA(); resulting in error: /home/hosting/data/scripts/dbclense.sh: line 12: syntax error...

5. Shell Programming and Scripting

Hey Perl Gurus

Hey guys im trying to get this if statement to work and i dont know whats wrong. can anybody help? if($author=~/\A+\Z/i)&&(length($author!=0)) { print " $author validation correct" } elsif($author!=~/\A+\Z/i)&&(length($author=0)) { $author='BLANK'; } else { ...

6. UNIX for Dummies Questions & Answers

Calling all the awk gurus out there.

Hi all, I just signed up to the forums, although, I have lurked on here for awhile. Anyways, my issue is I am trying to get awk to spit out something I can use without having to spend hours in excel hell haha. So, I used sed to replace the spaces with semicolons and redirected that to a file. ...

7. Shell Programming and Scripting

Question to gurus about sed.

Hi Folks. I need change something into file and after all manipulation I need delete only last COMMA into this piece of code -> GROUP 1 ( '/oralog1/ORAPRD/log01a.dbf', '/oralog2/ORAPRD/log01b.dbf' ) SIZE 512M, GROUP 2 ( '/oralog1/ORAPRD/log02a.dbf', ...

8. Shell Programming and Scripting

Question to gurus with expect

Hi., I need to ask question for expect script. I have prompt like # and very long script (orachk). I added to expect script line set prompt "(%|#|\\\$) $" and insert into it also piece of code ---- expect { timeout { puts "Running..." exp_continue } ...

9. What is on Your Mind?

Moving from Desktop View to Mobile View

See attached video for a demo on how to move back and forth from the desktop view to the mobile view. Currently this only works for the home page, but I will work on some new PHP code in the future to make this work with the page we are currently on. Edit: The issue with making every page ...

LEARN ABOUT DEBIAN

bt-serial

bt-serial(1)							    bluez-tools 						      bt-serial(1)

NAME

       bt-serial - a bluetooth serial manager

SYNOPSIS

       bt-serial [OPTION...]

       Help Options:
	 -h, --help

       Application Options:
	 -a, --adapter=<name|mac>
	 -c, --connect <name|mac> <pattern>
	 -d, --disconnect <name|mac> <tty_device>

DESCRIPTION

       This utility is used to manage serial service connections.

OPTIONS

       -h, --help
	   Show help

       -a, --adapter <name|mac>
	   Specify adapter to use by his Name or MAC address
	   (if this option does not defined - default adapter used)

       -c, --connect <name|mac> <pattern>
	   Connects to a specific RFCOMM based service on a
	   remote device and then creates a RFCOMM TTY
	   device for it; `pattern` is a profile short name (spp, dun),
	   RFCOMM channel (1-30)

       -d, --disconnect <name|mac> <tty_device>
	   Disconnect a RFCOMM TTY device that has been created

AUTHOR

       Alexander Orlenko <zxteam@gmail.com>.

SEE ALSO

       bt-adapter(1) bt-agent(1) bt-audio(1) bt-device(1) bt-input(1) bt-monitor(1) bt-network(1)

								    2010-08-12							      bt-serial(1)