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: bobsh...@ntlworld.com > To: mysql@lists.mysql.com > CC: win32-h...@lists.mysql.com > 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