accessing mysql from ms-sql

7 More Discussions You Might Find Interesting

1. Programming

[SQL] Insert content file to mysql

2. Shell Programming and Scripting

Accessing the variable from pl sql bolck

I hve a PL SQL block in unix where i define a variable "var_px_cat" and use it for taking count SELECT COUNT(*) INTO var_px_cat FROM A WHERE B = '$CATEGORIE_ID'; Now how do I access the variable "var_px_cat" in unix after exiting from pl sql block.

3. UNIX for Advanced & Expert Users

Accessing PL/SQL OUT variables in Korn Shell Script

Hello All, I was just wondering if there is any direct way to access PL/SQL OUT variables from Korn Shell Script. I could already figure out how to return a single value back from PL/SQL to Shell Script (using bind variable). But, what if we want to return multiple values? One option I...

4. Shell Programming and Scripting

how to break mysql dump sql file

Hi folks I have mysql dump which having insert queries, i want to break that file when 10 complete "INSERTS" lines so extract that line and store in 1.sql and 2.sql and for next 10 insert lines. pls guide me how can i do that. Regards, Bash

5. Shell Programming and Scripting

Shell script for accessing a file in the network drive and invoking oracle sql loader

Hi, Please let me know if anybody is having a solution handy for the below tasks... It would be helpful if somebody can resolve my query. I am new to unix and oracle environment and looking for some online reference for completing a task. Task: Check if the network drive exists Check...

6. UNIX for Dummies Questions & Answers

mysql -u root < start_script.sql

what is the meaning of the line below? what is trying to be done by that line? can you explain the syntax? mysql -u root < start_script.sql

7. HP-UX

Accessing databases using sql*plus on HP box

When I try to connect to databse from HP box using the following command sqlplus <username>@<databasename> I get this error message: ksh: <database name> : not found I can connect to the database outside the UNIX box using sqlplus though. Looks like the problem is the way HP Unix is...

LEARN ABOUT DEBIAN

bp_meta_gff

BP_META_GFF(1p) 					User Contributed Perl Documentation					   BP_META_GFF(1p)

NAME

       bp_meta_gff.pl - Get/set Bio::DB::GFF meta-data

SYNOPSIS

	 # set the following meta data values
	 % bp_meta_gff.pl -d testdb tag1=value1 tag2=value2

	 # get the indicated meta data value
	 % bp_meta_gff.pl -d testdb tag1 tag2

DESCRIPTION

       This script gets or sets metadata in a Bio::DB::GFF database.  Not all adaptors support this operation!	To set a series of tags, pass a
       set of tag=value pairs to the script.  To get the contents of a series of tags, pass the bare tag names.

       The output from the get operation will be an easily parseable set of tag=value pairs, one per line.

COMMAND-LINE OPTIONS
       Command-line options can be abbreviated to single-letter options.  e.g. -d instead of --database.

	  --database <dsn>	Mysql database name (default dbi:mysql:test)
	  --adaptor <adaptor>	Mysql adaptor (default dbi::mysqlopt)
	  --user    <user>	Username for mysql authentication
	  --pass    <password>	Password for mysql authentication

SEE ALSO

       Bio::DB::GFF

AUTHOR

       Lincoln Stein, lstein@cshl.org

       Copyright (c) 2002 Cold Spring Harbor Laboratory

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.  See DISCLAIMER.txt for
       disclaimers of warranty.

perl v5.14.2							    2012-03-02							   BP_META_GFF(1p)

Programming