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 PROTECTED]> wrote on 08/10/2004 08:46:09 AM: > > > > 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.upscene.com > > > > Martijn Tonies schrieb am 10.08.2004 14:27: > > > > > > > > > > >>yes!! > > >> > > >> > > > > > >Did you find > > >SHOW [FULL] COLUMNS FROM <tablename> > > > > > >I know I did when looking through the docs... > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
