Tag: sqlite
-
Show Columns for a table in SQLite
Here’s the query you can run in SQLite to return all the columns from a specified table in SQLite.
-
Split a column with a delimiter in SQLite
Let’s say you have a column with someone’s full name stored in the format of “LastName, FirstName” and you would rather have two columns – one with the first name and one with the last name. The below code to split out the names in your results window.
-
Cleaning up non-ISO Dates in SQLite
SQLite doesn’t have a date storage class which makes working with dates a bit tricky. You’ll have to store the data as ‘Text’. You can read more about that here.
-
Update a table with values from a related table in SQLite
Updating a column in a table based on values in a second table proved to be quite a difficult operation in SQLite. It’s not as straightforward as it is in MySQL where one can use an inner join.