When working with SQL, we can use the INSERT statement to insert a new row into a table. But what if we want to insert more than one row?
Fortunately, we can still use the INSERT statement. Below is a quick example that inserts multiple rows using SQL.
If you’re not sure if a table has a generated column in SQLite, you can quickly find out with either the .schema command, or by querying the sqlite_schema table.
We can use the SQL INSERT statement to insert a row into a table. We can also use it to insert more than one row.
Below are seven ways to insert multiple rows into a table in SQL. Most of these examples should work in the major RDBMSs, with the possible exception of Oracle. But no worries, I’ve included an example just for Oracle.
Continue readingIn SQLite, we can use the TIME() function to add a given number of minutes to a time value.
If we’re dealing with datetime values, we can use the DATETIME() function.
In SQLite, we can use the TIME() function to add a given number of hours to a time value.
If we’re dealing with datetime values, we can use the DATETIME() function.
Below are examples of using SQL to return the first day of the month across various DBMSs.
This could be the first day of the current month, or the first day of a month based on a given date.
Continue readingIn SQLite, we can use the DATE() function to subtract one or more months from a date.
For datetime values, we can use the DATETIME() function.
In SQLite, the CASE expression compares a list of conditions and returns one of multiple possible expressions.
The CASE expression is included in the SQL standard (ISO/IEC 9075), and most major RDBMSs support it.
We can use SQLite’s DATE() function to return the first, second, third, fourth, etc instance of a given day within a given year.
We can use the same technique to return the first Monday of each month in the year.
It’s not limited to Monday though. The same techniques can be used on Tuesday, Wednesday, Thursday, Friday, etc.
Continue readingIn SQLite, we can use the TIME() function to subtract one or more seconds from a time value.
For datetime values, we can use the DATETIME() function.