List:General Discussion« Previous MessageNext Message »
From:SGreen Date:August 10 2004 1:25pm
Subject:Re: get extended infos over table-columns
View as plain text  
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
> 

Thread
get extended infos over table-columnsMichael Seele10 Aug
  • Re: get extended infos over table-columnsMartijn Tonies10 Aug
    • Re: get extended infos over table-columnsMichael Seele10 Aug
  • Re: get extended infos over table-columnsMartijn Tonies10 Aug
    • Re: get extended infos over table-columnsMichael Seele10 Aug
  • Re: get extended infos over table-columnsMartijn Tonies10 Aug
    • Re: get extended infos over table-columnsSGreen10 Aug