mysql storage folder
/var/lib/mysql-files/
Keyboard Info
Clear MariaDB screen ctrl + L
alt-gr + # = ’ This is the correct syntax- Normal Comma’s don’t work!
Beispiel Datenbank / 3 Tabellen
MariaDB [drink]> SHOW TABLES;
+—————–+
| Tables_in_drink |
+—————–+
| awesome |
| awesome2 |
| company |
| list |
| taste |
+—————–+
MariaDB [drink]> DESCRIBE company;
+————+——————+——+—–+———+—————-+
| Field | Type | Null | Key | Default | Extra |
+————+——————+——+—–+———+—————-+
| company_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| comp_name | varchar(15) | NO | | NULL | |
+————+——————+——+—–+———+—————-+
MariaDB [drink]> DESCRIBE list;
+————+————-+——+—–+———+——-+
| Field | Type | Null | Key | Default | Extra |
+————+————-+——+—–+———+——-+
| taste_name | varchar(30) | NO | | NULL | |
| comp_name | varchar(15) | YES | | NULL | |
| lager | varchar(3) | YES | | NULL | |
+————+————-+——+—–+———+——-+
MariaDB [drink]> EXPLAIN taste;
+————+——————+——+—–+———+—————-+
| Field | Type | Null | Key | Default | Extra |
+————+——————+——+—–+———+—————-+
| taste_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| taste_name | varchar(30) | NO | | NULL | |
| diet | varchar(1) | YES | | NULL | |
| rating | varchar(1) | YES | | NULL | |
| company_id | varchar(1) | YES | | NULL | |
| barcode | varchar(30) | YES | | NULL | |
| lager | varchar(3) | YES | | NULL | |
| image | mediumblob | YES | | NULL | |
+————+——————+——+—–+———+—————-+
8 rows in set (0.004 sec)
Erstelle View mit Bild (Blob)
MariaDB [drink]> CREATE VIEW awesome2 AS SELECT taste.taste_name, company.comp_name, taste.diet, taste.rating, taste.lager, taste.barcode, taste.image FROM taste LEFT JOIN company ON company.company_id = taste.company_id;
Erstelle View
CREATE VIEW awesome AS SELECT taste.taste_name, company.comp_name, taste.diet, taste.rating, taste.lager, taste.barcode FROM taste LEFT JOIN company ON company.company_id = taste.company_id;
Ergiebnis von Erstelle View
MariaDB [drink]> SELECT * FROM awesome;
+—————————–+———–+——+——–+——-+—————+
| taste_name | comp_name | diet | rating | lager | barcode |
+—————————–+———–+——+——–+——-+—————+
| Absolute Zero | monster | 1 | 4 | 8 | 5063356242 |
| Punch Dr Pepper | monster | 0 | 5 | 2 | 5063356280 |
| Ultra | monster | 1 | 4 | 8 | 506337500401 |
| Juiced Mango Loco | monster | 0 | 3 | 4 | 50617888510 |
| Ultra Violet | monster | 1 | 3 | 3 | 506178836 |
| El Mango | rockstar | 0 | 5 | 10 | 4068020341 |
| Grape | rockstar | 0 | 3 | 3 | 4068020136 |
| Passion Fruitas | rockstar | 0 | 4 | 1 | 4068020372 |
| Mango Orange Passionfruit | rockstar | 0 | 3 | 1 | 4068016041 |
| Red Bull Zero | red bull | 1 | 4 | 29 | 90415296 |
| Red Bull Energy | red bull | 0 | 3 | 6 | 90162565 |
| Winter Himbeere | red bull | 0 | 4 | 1 | 9044605 |
| Blue Heidelbeere | red bull | 0 | 4 | 2 | 90376603 |
| Blueberry Pomegranate Acai | rockstar | 1 | 2 | 2 | 4068020662 |
| Original Performance Energy | rockstar | 0 | 4 | 2 | 406801683 |
| Frozen Watermelon | rockstar | 0 | 3 | 1 | 4060800179678 |
| Ultra Paradise | monster | 1 | 2 | 1 | 5060639126897 |
| Monster Energy Classic | monster | 0 | 2 | 1 | 5060335635228 |
| Punch Pink | monster | 0 | 3 | 1 | 5060517883607 |
| Ultra Red | monster | 1 | 5 | 1 | 5060337500609 |
| Assault | monster | 0 | 4 | 2 | 5060335635235 |
| Rockstar Original | rockstar | 0 | 3 | 1 | 4060800160003 |
| Punch Beige | monster | 0 | 3 | 1 | 5060639126682 |
+—————————–+———–+——+——–+——-+—————+
Erstelle Left Join
MariaDB [drink]> SELECT taste.taste_name, company.comp_name, taste.diet, taste.rating, taste.lager, taste.barcode FROM taste LEFT JOIN company ON company.company_id = taste.company_id SORT BY taste.rating;