mysql query for multiple columns from multiple tables in a DB Post: 302537019

10 More Discussions You Might Find Interesting

1. Programming

mysql query multiple records for one field

Hello Group, What I have is a database with about a dozen fields and one being "City". What I would like to do is to have a custom query on a single field for multiple items (cities) but I don't know how to do this. I know this is probably kids play for most of you but I am lost. What I have...

2. Shell Programming and Scripting

Awk match multiple columns in multiple lines in single file

Hi, Input 7488 7389 chr1.fa chr1.fa 3546 9887 chr5.fa chr9.fa 7387 7898 chrX.fa chr3.fa 7488 7389 chr21.fa chr3.fa 7488 7389 chr1.fa chr1.fa 3546 9887 chr9.fa chr5.fa 7898 7387 chrX.fa chr3.fa Desired Output 7488 7389 chr1.fa chr1.fa 2 3546 9887 chr5.fa chr9.fa 2...

3. Shell Programming and Scripting

Compare multiple files with multiple number of columns

Hi, input file1 abcd 123 198 xyz1:0909090-0909091 ghij 234 999 xyz2:987654:987655 kilo 7890 7990 xyz3:12345-12357 prem 9 112 xyz5:97-1134 input file2 abcd 123 198 xyz1:0909090-0909091 -9.122 0 abed 88 98 xyz1:98989-090808 -1.234 1.345 ghij 234 999 xyz2:987654:987655 -10.87090909 5...

4. Shell Programming and Scripting

Reading multiple values from multiple lines and columns and setting them to unique variables.

Hello, I would like to ask for help with csh script. An example of an input in .txt file is below, the number of lines varies from file to file and I have 2 or 3 columns with values. I would like to read all the values (probably one by one) and set them to independent unique variables that...

5. Shell Programming and Scripting

UPDATE COmmand post comparing 2 columns in 2 mysql tables

my queryis : select distinct m.name, item_count, item from master m join client p on m.name=p.name where item_count = 1 and item > 1; But how should I update them? i used update statetment : Update from client Set item =1 where m.name=p.name and item_count=1 AND item>1 Is this wrong?

6. Shell Programming and Scripting

Assigning multiple column's value from Oracle query to multiple variables in UNIX

Hi All, I need to read values of 10 columns from oracle query and assign the same to 10 unix variables. The query will return only one record(row). I tried to append all these columns using a delimiter(;) in the select query and assign the same to a single variable(V) in unix. I thought I...

7. Shell Programming and Scripting

Removing carriage returns from multiple lines in multiple files of different number of columns

Hello Gurus, I have a multiple pipe separated files which have records going over multiple Lines. End of line separator is \n and records going over multiple lines have <CR> as separator. below is example from one file. 1|ABC DEF|100|10 2|PQ RS T|200|20 3| UVWXYZ|300|30 4| GHIJKL|400|40...

8. Shell Programming and Scripting

Shell script automation using cron which query's MySQL Tables

What I have: I have a input.sh (script which basically connect to mysql-db and query's multiple tables to write back the output to output1.out file in a directory) note: I need to pass an integer (unique_id = anything b/w 1- 1000) next to the script everytime I run the script which generates...

9. UNIX for Beginners Questions & Answers

Using bash script : How to Import data from a dsv file into multiple tables in mysql

HI I have a dsv file that looks like: <<BOF>> record_number|id_number|first name|last name|msisdn|network|points|card number|gender 312|9101011234011|Test Junior|Smith|071 123 4321|MTN|73|1241551413214444|M 313|9012023213011|Bob|Smith|27743334321|Vodacom|3|1231233232323244|M...

10. UNIX for Beginners Questions & Answers

Export Oracle multiple tables to multiple csv files using UNIX shell scripting

Hello All, just wanted to export multiple tables from oracle sql using unix shell script to csv file and the below code is exporting only the first table. Can you please suggest why? or any better idea? export FILE="/abc/autom/file/geo_JOB.csv" Export= `sqlplus -s dev01/password@dEV3...

LEARN ABOUT DEBIAN

ophcrack-cli

OPHCRACK(1)							   User Commands						       OPHCRACK(1)

NAME

       Ophcrack - a Microsoft Windows password cracker using rainbow tables.

DESCRIPTION

       Ophcrack is a Windows password cracker based on a time-memory trade-off using rainbow tables.
       This is a new variant of Hellman's original trade-off, with better performance.
       It recovers 99.9% of alphanumeric passwords in seconds.

       Ophcrack works for Windows NT/2000/XP/Vista.

       Ophcrack can be used with command line using the options below, or can be run as a pure graphical software.

       If you have installed ophrack-cli package, graphical interface is not available.

SYNOPSIS

       ophcrack [options]

OPTIONS

       -a     disable audit mode (default)

       -A     enable audit mode

       -b     disable bruteforce

       -B     enable bruteforce (default)

       -c <file>
	      specify the config file to use

       -D     display (lots of!) debugging information

       -d <dir>
	      specify tables base directory

       -e     do not display empty passwords

       -f <file>
	      load hashes from the specified file (pwdump or session)

       -g     disable GUI

       -h     display this information

       -i     hide usernames

       -I     show usernames (default)

       -l <file>
	      log all output to the specified file

       -n <num>
	      specify the number of threads to use

       -o <file>
	      write cracking output to file in pwdump format

       -q     quiet mode

       -r     launch the cracking when ophcrack starts (GUI only)

       -s     disable session auto-saving

       -S <session_file>
	      specify the file to use to automatically save the progress of the search

       -u     display statistics when cracking ends

       -t table1[,a[,b,...]][:table2[,a[,b,...]]]
	      specify which table to use in the directory given by -d

       -v     verbose

       -w <dir>
	      load hashes from encrypted SAM file in directory dir

       -x     export data in CSV format to the file specified by -o

EXAMPLES

       ophcrack -g -d /path/to/tables -t xp_free_fast,0,3:vista_free -f in.txt

       Launch  ophcrack  in  command  line  using  tables 0 and 3 in /path/to/tables/xp_free_fast and all tables in /path/to/tables/vista_free and
       cracks hashes from pwdump file in.txt

SEE ALSO

       Homepage: http://ophcrack.sourceforge.net/
       Free rainbow tables: http://ophcrack.sourceforge.net/tables.php

AUTHOR

       This manual page was written by Adam Cecile <gandalf@le-vert.net> for the Debian system (but may be used by others).
       Permission is granted to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2  or  any
       later version published by the Free Software Foundation
       On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.

3.2.0								    March 2009							       OPHCRACK(1)