Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Retrieve column type for existing column?

Status
Not open for further replies.
MatthewP

MatthewP

Programmer
Jan 16, 2001
176
GB
This has to be an easy thing to do but I can't find the answer anywhere. I need to know what column type an existing table column is - how can I retrieve this information?

Thanks,
matt.
 
Sort by date Sort by votes
maybe I don't understand the question but... try.

mysql> explain myTable;

it'll show you the layout.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bharons
  • Locked
  • Question
function argument value, type or count is invalid
Replies
3
Views
333
bharons
bharons
boylesg
  • Locked
  • Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
462
spamjim
spamjim
penguinspeaks
  • Locked
  • Question
Update column based on input from another column 3
Replies
6
Views
404
penguinspeaks
penguinspeaks
jawadfrhad
  • Locked
  • Question
how make row to column
Replies
4
Views
163
jawadfrhad
jawadfrhad
AbidingDude
  • Locked
  • Question
One Constraint for Multiple Columns 1
Replies
2
Views
296
AbidingDude
AbidingDude

Part and Inventory Search

Sponsor

Back
Top