Skip to content

TIY-DC-ROR-2015-May/raw-sql-challenge

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Generating SQL

Okay, typing out SQL is really tedious. Let's do better.

  • Connect to the provided db.sqlite3 database. How many users are in the users table?
  • What is the SQL command to add a new user to the database? Add yourself using the sqlite console.
  • We have a list of new users to add to the database in new_users.csv. Look at script.rb and finish it so that it inserts the users from the file. How many users are there after running the script?

N.B.: under normal circumstances, it's a bad idea to check your database file in to git. Please don't take this as an example.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages