Identifying a missing primary key


 
Thread Tools Search this Thread
Top Forums Programming Identifying a missing primary key
# 1  
Old 04-06-2013
Identifying a missing primary key

I have the following method to identify missing primary keys in a MySQL database schema:
Code:
USE information_schema;
SELECT xx.table_name 
FROM (SELECT table_name, COUNT(*) FROM columns WHERE table_schema = @myDB GROUP BY table_name, column_key) xx 
GROUP BY xx.table_name 
HAVING COUNT(*) = 1;

I am not particularly enamored with the xx solution, because one can never be certain that a table with that name does not already exist. Does anyone know of a solution which is more elegant?
Login or Register to Ask a Question

Previous Thread | Next Thread

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... (10 Replies)
Discussion started by: nalu
10 Replies

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> ... (4 Replies)
Discussion started by: Rajeev_hbk
4 Replies

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... (1 Reply)
Discussion started by: Wpgn
1 Replies

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 Replies)
Discussion started by: rramkrishnas
5 Replies

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... (13 Replies)
Discussion started by: gw1500se
13 Replies

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... (2 Replies)
Discussion started by: LMHmedchem
2 Replies

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;... (5 Replies)
Discussion started by: yifangt
5 Replies

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. ... (1 Reply)
Discussion started by: aixlover
1 Replies

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 (2 Replies)
Discussion started by: vibhor_agarwali
2 Replies
Login or Register to Ask a Question
Alzabo::Table(3pm)					User Contributed Perl Documentation					Alzabo::Table(3pm)

NAME
Alzabo::Table - Table objects SYNOPSIS
use Alzabo::Table; my $t = $schema->table('foo'); foreach $pk ($t->primary_keys) { print $pk->name; } DESCRIPTION
Objects in this class represent tables. They contain foreign key, index, and column objects. METHODS
schema Returns the "Alzabo::Schema" object to which this table belongs. name Returns the name of the table. column ($name) Returns the "Alzabo::Column" object that matches the name given. An "Alzabo::Exception::Params" exception is throws if the table does not contain the column. columns (@optional_list_of_column_names) If no arguments are given, returns a list of all "Alzabo::Column" objects in the schema, or in a scalar context the number of such tables. If one or more arguments are given, returns a list of table objects with those names, in the same order given. An "Alzabo::Exception::Params" exception is throws if the table does not contain one or more of the specified columns. has_column ($name) Returns a voolean value indicating whether the column exists in the table. primary_key In array context, return an ordered list of column objects that make up the primary key for the table. In scalar context, it returns the first element of that list. primary_key_size The number of columns in the table's primary key. column_is_primary_key ("Alzabo::Column" object) Returns a boolean value indicating whether the column given is part of the table's primary key. This method is really only needed if you're not sure that the column belongs to the table. Otherwise just call the "Alzabo::Col- umn->is_primary_key" method on the column object. attributes A table's attributes are strings describing the table (for example, valid attributes in MySQL are thing like "TYPE = INNODB". Returns a list of strings. has_attribute This method can be used to test whether or not a table has a particular attribute. By default, the check is case-insensitive. * attribute => $attribute * case_sensitive => 0 or 1 (defaults to 0) Returns a boolean value indicating whether the table has this particular attribute. foreign_keys Thie method takes two parameters: * column => "Alzabo::Column" object * table => "Alzabo::Table" object It returns a list of "Alzabo::ForeignKey" objects from the given column to the given table, if they exist. In scalar context, it returns the first item in the list. There is no guarantee as to what the first item will be. An "Alzabo::Exception::Params" exception is throws if the table does not contain the specified column. foreign_keys_by_table ("Alzabo::Table" object) Returns a list of all the "Alzabo::ForeignKey" objects to the given table. In scalar context, it returns the first item in the list. There is no guarantee as to what the first item will be. foreign_keys_by_column ("Alzabo::Column" object) Returns a list of all the "Alzabo::ForeignKey" objects that the given column is a part of, if any. In scalar context, it returns the first item in the list. There is no guarantee as to what the first item will be. An "Alzabo::Exception::Params" exception is throws if the table does not contain the specified column. all_foreign_keys Returns a list of all the "Alzabo::ForeignKey" objects for this table. In scalar context, it returns the first item in the list. There is no guarantee as to what the first item will be. index ($index_id) This method expects an index id as returned by the "Alzabo::Index->id" method as its parameter. The "Alzabo::Index" object matching this id, if it exists in the table. An "Alzabo::Exception::Params" exception is throws if the table does not contain the specified index. has_index ($index_id) This method expects an index id as returned by the "Alzabo::Index->id" method as its parameter. Returns a boolean indicating whether the table has an index with the same id. indexes Returns all the "Alzabo::Index" objects for the table. comment Returns the comment associated with the table object, if any. AUTHOR
Dave Rolsky, <autarch@urth.org> perl v5.8.8 2007-12-23 Alzabo::Table(3pm)