Query tweater (4)
There are also dedicated SQL functions that you can use in the WHERE
clause of an SQL query. For example, CHAR_LENGTH()
returns the number of characters in a string.
This exercise is part of the course
Intermediate Importing Data in R
Exercise instructions
- Create a data frame,
short
, that selects theid
andname
columns from theusers
table where the number of characters in thename
is strictly less than 5. - Print
short
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Connect to the database
library(DBI)
con <- dbConnect(RMySQL::MySQL(),
dbname = "tweater",
host = "courses.csrrinzqubik.us-east-1.rds.amazonaws.com",
port = 3306,
user = "student",
password = "datacamp")
# Create data frame short
# Print short