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" <m.tonies@stripped> 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/mysql?unsub=1
>
