DB Query Examples: Revision history

From 2nd Book
Jump to navigationJump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

29 January 2025

  • curprev 09:5109:51, 29 January 2025Pig talk contribs 760 bytes +760 Created page with " === '''Query Examples''' === # '''Find all definitions for a given Hebrew word''' # SELECT d.definition_type, d.definition_text FROM Definitions d JOIN Hebrew_Words hw ON d.word_id = hw.word_id WHERE hw.hebrew_word = 'אֲבִי'; '''Get all permutations for a word:''' SELECT wf.formation, wf.formation_meaning FROM Word_Formations wf JOIN Hebrew_Words hw ON wf.word_id = hw.word_id WHERE hw.hebrew_word = 'אמר'; '''Find typological meanings linked to a word:..." Tag: Visual edit