![]() To find a message that matches some text: JOIN message ON chat_message_ssage_id = message. To see all of your messages with a nicely formatted date:ĭatetime (message.date / 1000000000 + strftime ("%s", ""), "unixepoch", "localtime") AS message_date, With these, we can build some pretty cool queries. There are also join tables, which show the relationships between tables (handles to chats, chats to messages, messages to attachments, etc.). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |