Identifying a missing primary key

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Identifying missing file dates

Hi Experts, I have written the below script to check the missing files based on the date in the file name from current date to in a given interval of days. In the file names we have dates along with some name. ex:jera_sit_2017-04-25-150325.txt. The below script is working fine if we have only...

2. Shell Programming and Scripting

Shell Script @ Find a key word and If the key word matches then replace next 7 lines only

Hi All, I have a XML file which is looks like as below. <<please see the attachment >> <?xml version="1.0" encoding="UTF-8"?> <esites> <esite> <name>XXX.com</name> <storeId>10001</storeId> <module> ...

3. Solaris

Primary key issue when running Oracle sql file

I got a issue with running the following script below if I remove the inserts and alter table the tables will install just fine but if I try and do the full thing in one go i get the below error dose any one have any ideas on this problem? its got me spinning, thanks. REM REM List of...

4. Shell Programming and Scripting

Identifying Missing File Sequence

Hi, I have a file which contains few columns and the first column has the file names, and I would like to identify the missing file sequence number form the file and would copy to another file. My files has data in below format. APKRISPSIN320131231201319_0983,1,54,125,...

5. Red Hat

Yum - resolving missing dependencies that are not missing

I am trying to install VirtualBox on RHEL 5 but I need the 32 bit version for 32 bit Windows. When I run yum I get the following: sudo yum localinstall /auto/spvtg-it/spvss-migration/Software/VirtualBox-4.3-4.3.2_90405_el6-1.i686.rpm Loaded plugins: fastestmirror Setting up Local Package...

6. SuSE

How to resolve missing missing dependencies with opensuse 11.3 and 12.3?

Hello, This is a programming question as well as a suse question, so let me know if you think I should post this in programming. I have an application that I compiled under opensuse 12.2 using g77-3.3/g++3.3. The program compiles and runs just fine. I gave the application to a colleague who...

7. Programming

MySQL auto_increment, primary key

Hello, I want to create a table in mysql database by loading the local file. I am confused with the auto_increment column (say Run_ID) that I want to set it as primary key. My questions are: 1) Do I need add this Run_ID in my file ready? then this does not make any sense to the auto_increment;...

8. Solaris

Solaris 8 ssh public key authentication issue - Server refused our key

Hi, I've used the following way to set ssh public key authentication and it is working fine on Solaris 10, RedHat Linux and SuSE Linux servers without any problem. But I got error 'Server refused our key' on Solaris 8 system. Solaris 8 uses SSH2 too. Why? Please help. Thanks. ...

9. UNIX for Dummies Questions & Answers

Pressing backspace key simulates enter key

Hi, Whenever i press the backspace key, a new line appears, i.e. it works like a enter key. :confused: Thanks

LEARN ABOUT DEBIAN

sqlt-diagram

SQLT-DIAGRAM(1p)					User Contributed Perl Documentation					  SQLT-DIAGRAM(1p)

NAME

       sqlt-diagram - Automatically create a diagram from a database schema

SYNOPSIS

	 ./sqlt-diagram -d|-f|--from|--db=db_parser [options] schema.sql

	 Options:

	   -o|--output	      Output file name (default STDOUT)
	   -i|--image	      Output image type ("png" or "jpeg," default "png")
	   -t|--title	      Title to give schema
	   -c|--cols	      Number of columns
	   -n|--no-lines      Don't draw lines
	   --font-size	      Font size ("small," "medium," "large," or "huge,"
			      default "medium")
	   --gutter	      Gutter size between tables
	   --color	      Add colors
	   --show-fk-only     Only show fields that act as primary
			      or foreign keys

	   --natural-join     Perform natural joins
	   --natural-join-pk  Perform natural joins from primary keys only
	   -s|--skip	      Fields to skip in natural joins
	   --skip-tables      Comma-separated list of table names to exclude
	   --skip-tables-like Comma-separated list of regexen to exclude tables
	   --debug	      Print debugging information

DESCRIPTION

       This script will create a picture of your schema.  Only the database driver argument (for SQL::Translator) is required.	If no output file
       name is given, then image will be printed to STDOUT, so you should redirect the output into a file.

       The default action is to assume the presence of foreign key relationships defined via "REFERENCES" or "FOREIGN KEY" constraints on the
       tables.	If you are parsing the schema of a file that does not have these, you will find the natural join options helpful.  With natural
       joins, like-named fields will be considered foreign keys.  This can prove too permissive, however, as you probably don't want a field
       called "name" to be considered a foreign key, so you could include it in the "skip" option, and all fields called "name" will be excluded
       from natural joins.  A more efficient method, however, might be to simply deduce the foriegn keys from primary keys to other fields named
       the same in other tables.  Use the "natural-join-pk" option to achieve this.

AUTHOR

       Ken Youens-Clark <kclark@cpan.org>.

perl v5.14.2							    2012-01-18							  SQLT-DIAGRAM(1p)

Programming