title: How to select all columns in dplyr/sql?
body: <p>I am connecting a MySQL data base with <code>dplyr</code> and handle the data with <code>dplyr</code> and the <code>%&gt;%</code> operatot subsequently.</p>
  
  <pre><code>conDplyr &lt;- src_mysql(user = db_user, password = db_pw, dbname = db_name, host = db_host, port = some_port)
  </code></pre>
  
  <p>As long as I select a certain number of columns but all, it works!</p>
  
  <pre><code>dat &lt;- conDplyr %&gt;%
   tbl('table_name') %&gt;%
   select(c1, c2, c3, c4) %&gt;%
   filter(!is.null(c4))
  </code></pre>
  
  <p>Now, I ran over a use case, in which I need to select all columns (whole table). All tutorials I found (about <code>dplyr</code>) handled this by selecting the whole dataframe (which I do not have)</p>
  
  <pre><code>some_dataframe &lt;- ...
  select(some_dataframe)
  </code></pre>
  
  <p>I have not found any suggestions in combination with databases. Perhaps the day was too long. Does anybody could help me please?</p>
  
  <p>Best Rob</p>
  
  <pre><code>conDplyr &lt;- src_mysql(...)
  dat &lt;- conDplyr %&gt;%
  tbl('table_name') %&gt;%
  select(everything()) %&gt;%
  filter(!is.null(ean))
  </code></pre>
  
  <p>works just fine. Thanks! If I leave out the select the query results in an error (non-defined columns selected).
  Again, I did not just want to work with a already existing data frame, but with a table queried from a database, that`s why I am have to do, correct me if I am wrong, an select. </p>