SQL Techniques
Last updated
Was this helpful?
Last updated
Was this helpful?
Install which is a lightweight popular database
Install
SQLite: At a shell or DOS prompt, enter: "sqlite3 test.db". This will create a new database named "test.db". (You can use a different name if you like.)
DB Browser: Provides an easier user interface to execute SQL queries
type total_calories biking 220 football 410 swimming 260
Return the first non-null value in a list