@MTBeeSQL

1 Followers
15 Following
21 Posts
Keeping my hand in for using SQL - hoping to tutor/teach
Comparing Beekeeper Studio and DB Browser for SQLite
https://claude.ai/share/f002aa6a-1a90-4632-8534-472bcb5eb46d
Claude

Shared via Claude, an AI assistant from Anthropic

Claude

DB Browser for SQLite ...

If you have a ';' embedded in a larger comment /* ... ; ...*/
You will break the larger comment!

DB Browser for SQLite ... shift+f5

Executes the current sql line and includes the comment (if there is one) just before it...

Claude

Shared via Claude, an AI assistant from Anthropic

Claude
Use 'DB Browser for SQLite'! #SQL #SQLITE
Hoo-hoo! SQLite supports regexp (after a fashion)...
Example of Begin Transaction / Rollback (for SQLite)

#SQL

Made a script to execute the update described on page 277 or PracticalSQL.

[ch08.page.277-277.update.example.#2.sql ""https://drive.proton.me/urls/39K3N1JWV8#eWTxpry4clYn""]

**#SQL**

Made a script to execute the update described on page 277 or PracticalSQL.

[ch08.page.277-277.update.example.#1.sql ""https://drive.proton.me/urls/02EV352N00#twRktIILxDw4""]

#AutoKey

Created a 'sqlite_bookbiz_readonly' as well as 'sqlite_bookbiz' scripts.

Downloadable

sqlite_bookbiz.py
https://drive.proton.me/urls/NE5996N47R#w49QiDdABUR1

sqlite_bookbiz_readonly.py
https://drive.proton.me/urls/X4W3HBZ4YG#Y3Bp3aW1uq5L

Proton Drive

Securely store, share, and access your important files and photos. Anytime, anywhere.