mysql: change column to row

[Vivian Wang]

mysql,

Can I change the table one column to one row like this?
Table1:
key, count
A       123
B       456
C       789
to

Table2:
A       B       C
123     456     789


Thanks,

---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php