Re: get extended infos over table-columns

2004-08-10 Thread SGreen
And now that you know what TYPE a column is, you can use the information found on this page of the manual to answer your other questions http://dev.mysql.com/doc/mysql/de/Column_types.html Regards, Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Martijn Tonies" <[EMAIL PROT

Re: get extended infos over table-columns

2004-08-10 Thread Martijn Tonies
> YES! but these statement DON'T return my needed > infos("maximumDataLength", "numericPrecision", "numericScale")!!! Sure they do - in column "Type". With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www

Re: get extended infos over table-columns

2004-08-10 Thread Michael Seele
YES! but these statement DON'T return my needed infos("maximumDataLength", "numericPrecision", "numericScale")!!! Martijn Tonies schrieb am 10.08.2004 14:27: yes!! Did you find SHOW [FULL] COLUMNS FROM I know I did when looking through the docs... With regards, Martijn Tonies Database Wo

Re: get extended infos over table-columns

2004-08-10 Thread Martijn Tonies
> yes!! Did you find SHOW [FULL] COLUMNS FROM I know I did when looking through the docs... With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list ar

Re: get extended infos over table-columns

2004-08-10 Thread Michael Seele
yes!! Martijn Tonies schrieb am 10.08.2004 14:03: Hi, i need some extended infor over the table-columns! how can i get the "maximumDataLength", "numericPrecision", "numericScale" of a column? Did you check the documentation? With regards, Martijn Tonies Database Workbench - developer tool f

Re: get extended infos over table-columns

2004-08-10 Thread Martijn Tonies
Hi, > i need some extended infor over the table-columns! how can i get the > "maximumDataLength", "numericPrecision", "numericScale" of a column? Did you check the documentation? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Ups

get extended infos over table-columns

2004-08-10 Thread Michael Seele
hi, i need some extended infor over the table-columns! how can i get the "maximumDataLength", "numericPrecision", "numericScale" of a column? thx -- G & H Softwareentwicklung GmbH Tel.: +49(0)7451/53706-20 Robert-Bosch-Str. 23 Fax: +49(0)7451/53706-90 D-72160 Horb a.N.