https://mariadb.com/kb/en/library/mariadb-basics/
show databases;
create database book;
use book;
CREATE TABLE books ( isbn CHAR(20) PRIMARY KEY, title VARCHAR(50), author_id INT, publisher_id INT, year_pub CHAR(4), description TEXT );
DESCRIBE books; +--------------+-------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+--------------+-------------+------+-----+---------+-------+| isbn | varchar(20) | | PRI | | || title | varchar(50) | YES | | NULL | || author_id | int(11) | YES | | NULL | || publisher_id | int(11) | YES | | NULL | || year_pub | varchar(4) | YES | | NULL | || description | text | YES | | NULL | |+--------------+-------------+------+-----+---------+-------+
CREATE TABLE authors (author_id INT AUTO_INCREMENT PRIMARY KEY, name_last VARCHAR(50), name_first VARCHAR(50), country VARCHAR(50) );
INSERT INTO authors (name_last, name_first, country) VALUES('Kafka', 'Franz', 'Czech Republic');
INSERT INTO books (title, author_id, isbn, year_pub) VALUES('The Castle', '1', '0805211063', '1998');
INSERT INTO books (title, author_id, isbn, year_pub) VALUES('The Trial', '1', '0805210407', '1995'), ('The Metamorphosis', '1', '0553213695', '1995'), ('America', '1', '0805210644', '1995');
SELECT title FROM books;
SELECT title FROM books LIMIT 5;
SELECT title, name_last FROM books JOIN authors USING (author_id);
SELECT title AS 'Kafka Books'FROM books JOIN authors USING (author_id) WHERE name_last = 'Kafka'; +-------------------+| Kafka Books |+-------------------+| The Castle || The Trial || The Metamorphosis || America |+-------------------+
UPDATE books SET title = 'Amerika'WHERE isbn = '0805210644';
DELETE FROM books WHERE author_id = '2034';