rmysql - Using database column names as axis names for r plot -

rmysql - Using database column names as axis names for r plot -

i extracting info database using rmysql , using info plot graph.

the code have follows:

con <- dbconnect(dbdriver('mysql'), user = 'root', password = 'root', dbname='dbname') df <- data.frame(dbgetquery(con, paste('select * test'))) plot(df$id, df$uid, xlab='test1', ylab='test2', type='l')

this works absolutely fine question how can utilize db column name axis labels instead of hard coding labels in?

to utilize names of info frame come info base of operations utilize names(df) or if rownames utilize rownames(df).

then can subset 1 value, example, assuming names in column , id first column , uid second.

plot(df$id, df$uid, xlab=names(df)[1], ylab=names(df)[2], type='l')

r rmysql