Sqlite Intro Compucademy
A brief introduction to Sqlite, a lightweight database management system ideal for GCSE and A Level Computer Science study and use with Python.
You can check out our blog for articles on GCSE and A Level Computer Science and Python programming at https://compucademy.net/
SQL code is below. The DB Browser for Sqlite can be found here: https://sqlitebrowser.org/
```
CREATE TABLE cards (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
suit TEXT,
suit_symbol TEXT,
score INTEGER
);
INSERT INTO cards (name, suit, suit_symbol, score) VALUES
-- Spades
('A', 'spades', '♠', 1),
('2', 'spades', '♠', 2),
('3', 'spades', '♠', 3),
('4', 'spades', '♠', 4),
('5', 'spades', '♠', 5),
('6', 'spades', '♠', 6),
('7', 'spades', '♠', 7),
('8', 'spades', '♠', 8),
('9', 'spades', '♠', 9),
('10', 'spades', '♠', 10),
('J', 'spades', '♠', 11),
('Q', 'spades', '♠', 12),
('K', 'spades', '♠', 13),
-- Hearts
('A', 'hearts', '♥', 1),
('2', 'hearts', '♥', 2),
('3', 'hearts', '♥', 3),
('4', 'hearts', '♥', 4),
('5', 'hearts', '♥', 5),
('6', 'hearts', '♥', 6),
('7', 'hearts', '♥', 7),
('8', 'hearts', '♥', 8),
('9', 'hearts', '♥', 9),
('10', 'hearts', '♥', 10),
('J', 'hearts', '♥', 11),
('Q', 'hearts', '♥', 12),
('K', 'hearts', '♥', 13),
-- Clubs
('A', 'clubs', '♣', 1),
('2', 'clubs', '♣', 2),
('3', 'clubs', '♣', 3),
('4', 'clubs', '♣', 4),
('5', 'clubs', '♣', 5),
('6', 'clubs', '♣', 6),
('7', 'clubs', '♣', 7),
('8', 'clubs', '♣', 8),
('9', 'clubs', '♣', 9),
('10', 'clubs', '♣', 10),
('J', 'clubs', '♣', 11),
('Q', 'clubs', '♣', 12),
('K', 'clubs', '♣', 13),
-- Diamonds
('A', 'diamonds', '♦', 1),
('2', 'diamonds', '♦', 2),
('3', 'diamonds', '♦', 3),
('4', 'diamonds', '♦', 4),
('5', 'diamonds', '♦', 5),
('6', 'diamonds', '♦', 6),
('7', 'diamonds', '♦', 7),
('8', 'diamonds', '♦', 8),
('9', 'diamonds', '♦', 9),
('10', 'diamonds', '♦', 10),
('J', 'diamonds', '♦', 11),
('Q', 'diamonds', '♦', 12),
('K', 'diamonds', '♦', 13);
```
Auf dieser Seite können Sie das Online-Video Sqlite Intro Compucademy mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Compucademy 24 August 2019 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 155 Mal angesehen und es wurde von 2 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
