[R] How to get a table of MySQL database as a matrix variable in R

[Willie Y. CHEN]

It seems that the dbReadTable() method provided by RMySQL could not
get rid of the headers, neither the index column... So

1. Can I use read.table() method to get a table of MySQL database?
>From the help document the argument of 'file' of read.table() method
could be a connection...

2. How can I obtain a matrix from the database table contains all
elements except the headers and the index column?

Thanks a lot.

Regards,

Willie