From: Martin Gainty Date: April 12 2009 2:04pm Subject: RE: Newbie ... Schema details listing List-Archive: http://lists.mysql.com/mysql/217075 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_9cdbdc82-d5a8-4f9a-905b-f19b00569bf5_" --_9cdbdc82-d5a8-4f9a-905b-f19b00569bf5_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable in information_schema.tables e.g. SELECT AUTO_INCREMENT from information_schema.tables where=20 WHERE TABLE_NAME =3D "Products" AND TABLE_SCHEMA =3D "bs3578"=3B =20 Viel Gluck=2C Martin=20 ______________________________________________=20 Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung / Note= de d=E9ni et de confidentialit=E9=20 This message is confidential. If you should not be the intended receiver=2C= then we ask politely to report. Each unauthorized forwarding or manufactur= ing 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 Empfaeng= er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter= leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l= ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin= dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w= ir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EAtes= pas le destinataire pr=E9vu=2C nous te demandons avec bont=E9 que pour sat= isfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9e= ou la copie de ceci est interdite. Ce message sert =E0 l'information seule= ment et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant d= onn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation= =2C nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni= . > From: bobsharp@stripped > To: mysql@stripped > CC: win32-help@stripped > Subject: Newbie ... Schema details listing > Date: Sun=2C 12 Apr 2009 14:54:50 +0100 >=20 > I have written a .cfm to output a listing of columns with Name=2C Format= =2C Size=2C NULL=2C KEY=2C etc.=20 >=20 > One thing I need to include is whether the Primary Key is AUTO_INCREMENT= =20 > That element does not appear to be in the same SCHEMA table. >=20 > Where is it ? and How can I use it with this Query ... ? >=20 > > SELECT COLUMN_NAME AS pCname=2C=20 > DATA_TYPE AS pDtype=2C=20 > IS_NULLABLE AS pISnull=2C=20 > CHARACTER_MAXIMUM_LENGTH AS pMAXlen=2C > COLUMN_DEFAULT AS pCdefault=2C=20 > COLUMN_TYPE AS pCtype=2C > COLUMN_KEY AS pCkey=2C > NUMERIC_SCALE AS pNscale=2C =20 > NUMERIC_PRECISION AS pNprec > FROM INFORMATION_SCHEMA.COLUMNS=20 > WHERE TABLE_NAME =3D "Products" AND TABLE_SCHEMA =3D "bs3578"=3B= =20 > =20 >=20 >=20 >=20 >=20 > --=20 > 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 >=20 > The Professional version does not have this message _________________________________________________________________ Rediscover Hotmail=AE: Now available on your iPhone or BlackBerry http://windowslive.com/RediscoverHotmail?ocid=3DTXT_TAGLM_WL_HM_Rediscover_= Mobile1_042009= --_9cdbdc82-d5a8-4f9a-905b-f19b00569bf5_--