List:General Discussion« Previous MessageNext Message »
From:Martin Gainty Date:April 12 2009 2:04pm
Subject:RE: Newbie ... Schema details listing
View as plain text  
in  information_schema.tables
e.g.
SELECT AUTO_INCREMENT from information_schema.tables where 
WHERE   TABLE_NAME = "Products"  AND  TABLE_SCHEMA = "bs3578";     

Viel Gluck,
Martin 
______________________________________________ 
Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung / Note de déni
et de confidentialité 
This message is confidential. If you should not be the intended receiver, then we ask
politely to report. Each unauthorized forwarding or manufacturing of a copy is
inadmissible. This message serves only for the exchange of information and has no legal
binding effect. Due to the easy manipulation of emails we cannot take responsibility over
the the contents.
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so
bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer
Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und
entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von
E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous
n'êtes pas le destinataire prévu, nous te demandons avec bonté que
pour satisfaire informez l'expéditeur. N'importe quelle diffusion non
autorisée ou la copie de ceci est interdite. Ce message sert à
l'information seulement et n'aura pas n'importe quel effet légalement obligatoire.
Étant donné que les email peuvent facilement être sujets à la
manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu
fourni.






> From: bobsharp@stripped
> To: mysql@stripped
> CC: win32-help@stripped
> Subject: Newbie ... Schema details listing
> Date: Sun, 12 Apr 2009 14:54:50 +0100
> 
> I have written a .cfm to output a listing of columns with Name, Format, Size, NULL,
> KEY, etc. 
> 
> One thing I need to include is whether the Primary Key is  AUTO_INCREMENT 
> That element does not appear to be in the same SCHEMA table.
> 
> Where is it ?   and   How can I use it with this Query ...  ?
> 
> <CFQuery datasource="bs3578" name="pColumns" >
>      SELECT  COLUMN_NAME  AS  pCname, 
>              DATA_TYPE  AS  pDtype, 
>              IS_NULLABLE  AS  pISnull, 
>              CHARACTER_MAXIMUM_LENGTH  AS  pMAXlen,
>              COLUMN_DEFAULT  AS  pCdefault, 
>              COLUMN_TYPE  AS  pCtype,
>              COLUMN_KEY  AS  pCkey,
>              NUMERIC_SCALE  AS  pNscale,     
>              NUMERIC_PRECISION  AS  pNprec
>      FROM    INFORMATION_SCHEMA.COLUMNS 
>      WHERE   TABLE_NAME = "Products"  AND  TABLE_SCHEMA = "bs3578";     
> </cfquery>    
> 
> 
> 
> 
> -- 
> I am using the free version of SPAMfighter.
> We are a community of 6 million users fighting spam.
> SPAMfighter has removed 12962 of my spam emails to date.
> Get the free SPAMfighter here: http://www.spamfighter.com/len
> 
> The Professional version does not have this message

_________________________________________________________________
Rediscover Hotmail®: Now available on your iPhone or BlackBerry
http://windowslive.com/RediscoverHotmail?ocid=TXT_TAGLM_WL_HM_Rediscover_Mobile1_042009
Thread
Newbie ... Schema details listingBobSharp12 Apr
  • RE: Newbie ... Schema details listingMartin Gainty12 Apr