You can type "show create table <tablename>" to see the datatypes.
Waynn On 2/13/09, James Colannino <ja...@colannino.org> wrote: > Hey everyone. I've been reading the list for a long time, but have only > really posted to the mailing list a few times. I just had a quick > question about MySQL. I'm not sure if this is exactly relevant to PHP, > but it is for a PHP application I'm writing, so hopefully that makes > this question ok :) > > Basically, I was wondering if there are any queries in MySQL that I can > use to determine the data types used to construct a pre-existing table. > The reason I ask is that I went back to look at the data in a table I've > been using for a while and realized that I forgot to document what the > data types were (DOH!) I'm sure there's something, but I wasn't quite > sure what to google for, so I wasn't really able to turn up anything. > > Thanks! > > James > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
