Lehrer

an anonymous user · March 19, 2023

SQL

-- create a table
CREATE TABLE Lehrer (
  Lid INTEGER primary key,
  name TEXT NOT NULL,
  VORNAME TEXT NOT NULL
  );
-- insert some values
INSERT INTO LEHRER VALUES (1, 'Meier', 'Eckard');
INSERT INTO LEHRER VALUES (2, 'Gramse', 'Karl');
-- fetch some values
SELECT * FROM Lehrer where name like 'Gramse';

Output

(Run the program to view its output)

Comments

Please sign up or log in to contribute to the discussion.