SQLite Database: Notes

SQLite is free for everyone to use for any purpose.

SQLiteStudio is an open source SQLite database manager, released under GPLv3 license.

DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.

sqlite3 --version : check version

.open path-to-db-file : open database file
.tables : list all tables in database
.schema table_name : describe table schema
.help : get help
.quit : quit sqlite

HTML5: Complete Table Structure

Photo Credit: Gerald - pixabay.com <table> <caption style="caption-side:bottom;" >Caption here</caption> <thead> <tr> <th>Header1</th> <th>Header2</th> ... </tr> </thead> <tbody> <tr> <td>Column1</td> <td>Column2</td> ... </tr> ... </tbody> <tfoot>Footer here</tfoot> </table>

VMware Workstation: vmrun.exe

Using vmrun.exe to manage VMs on VMware Workstation

Chrome: Common Keyboard Shortcuts

Get more productive by learning and using shortcuts in Chrome browser.

luyện

Search This Blog