{"id":28,"date":"2019-02-08T00:30:12","date_gmt":"2019-02-08T00:30:12","guid":{"rendered":"https:\/\/zerosyntax.de\/?page_id=28"},"modified":"2021-04-20T08:56:00","modified_gmt":"2021-04-20T08:56:00","slug":"it-sicherheit","status":"publish","type":"page","link":"https:\/\/zerosyntax.de\/index.php\/it-sicherheit\/","title":{"rendered":"MySQL \/ MariaDB"},"content":{"rendered":"\n

mysql storage folder
\/var\/lib\/mysql-files\/
Keyboard Info
Clear MariaDB screen ctrl + L
alt-gr + # = \u2019 This is the correct syntax- Normal Comma’s don’t work!<\/p>\n\n\n\n

Beispiel Datenbank \/ 3 Tabellen<\/h2>\n\n\n\n

MariaDB [drink]> SHOW TABLES;
+—————–+
| Tables_in_drink<\/strong> |
+—————–+
| awesome |
| awesome2 |
| company |
| list |
| taste |
+—————–+<\/p>\n\n\n\n

MariaDB [drink]> DESCRIBE company<\/strong>;
+————+——————+——+—–+———+—————-+
| Field | Type | Null | Key | Default | Extra |
+————+——————+——+—–+———+—————-+
| company_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| comp_name | varchar(15) | NO | | NULL | |
+————+——————+——+—–+———+—————-+<\/p>\n\n\n\n

MariaDB [drink]> DESCRIBE list<\/strong>;
+————+————-+——+—–+———+——-+
| Field | Type | Null | Key | Default | Extra |
+————+————-+——+—–+———+——-+
| taste_name | varchar(30) | NO | | NULL | |
| comp_name | varchar(15) | YES | | NULL | |
| lager | varchar(3) | YES | | NULL | |
+————+————-+——+—–+———+——-+<\/p>\n\n\n\n

MariaDB [drink]> EXPLAIN taste<\/strong>;
+————+——————+——+—–+———+—————-+
| 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)<\/p>\n\n\n\n

Erstelle View mit Bild (Blob)<\/h2>\n\n\n\n

MariaDB [drink]> CREATE VIEW awesome2 AS SELECT taste<\/code>.taste_name<\/code>, company<\/code>.comp_name<\/code>, taste<\/code>.diet<\/code>, taste<\/code>.rating<\/code>, taste<\/code>.lager<\/code>, taste<\/code>.barcode<\/code>, taste<\/code>.image<\/code> FROM taste<\/code> LEFT JOIN company<\/code> ON company<\/code>.company_id<\/code> = taste<\/code>.company_id<\/code>;<\/p>\n\n\n\n

Erstelle View <\/h2>\n\n\n\n

CREATE VIEW awesome AS SELECT taste<\/code>.taste_name<\/code>, company<\/code>.comp_name<\/code>, taste<\/code>.diet<\/code>, taste<\/code>.rating<\/code>, taste<\/code>.lager<\/code>, taste<\/code>.barcode<\/code> FROM taste<\/code> LEFT JOIN company<\/code> ON company<\/code>.company_id<\/code> = taste<\/code>.company_id<\/code>;<\/p>\n\n\n\n

Ergiebnis von Erstelle View<\/h2>\n\n\n\n

MariaDB [drink]> SELECT * FROM awesome<\/strong>;
+—————————–+———–+——+——–+——-+—————+
| 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 |
+—————————–+———–+——+——–+——-+—————+<\/p>\n\n\n\n

Erstelle Left Join<\/h2>\n\n\n\n

MariaDB [drink]> SELECT taste<\/code>.taste_name<\/code>, company<\/code>.comp_name<\/code>, taste<\/code>.diet<\/code>, taste<\/code>.rating<\/code>, taste<\/code>.lager<\/code>, taste<\/code>.barcode<\/code> FROM taste<\/code> LEFT JOIN company<\/code> ON company<\/code>.company_id<\/code> = taste<\/code>.company_id<\/code> SORT BY taste<\/code>.rating<\/code>;<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

mysql storage folder\/var\/lib\/mysql-files\/Keyboard InfoClear MariaDB screen ctrl + Lalt-gr + # = \u2019 This is the correct syntax- Normal Comma’s don’t work! Beispiel Datenbank \/ 3 Tabellen MariaDB…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/zerosyntax.de\/index.php\/wp-json\/wp\/v2\/pages\/28"}],"collection":[{"href":"https:\/\/zerosyntax.de\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/zerosyntax.de\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/zerosyntax.de\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zerosyntax.de\/index.php\/wp-json\/wp\/v2\/comments?post=28"}],"version-history":[{"count":7,"href":"https:\/\/zerosyntax.de\/index.php\/wp-json\/wp\/v2\/pages\/28\/revisions"}],"predecessor-version":[{"id":996,"href":"https:\/\/zerosyntax.de\/index.php\/wp-json\/wp\/v2\/pages\/28\/revisions\/996"}],"wp:attachment":[{"href":"https:\/\/zerosyntax.de\/index.php\/wp-json\/wp\/v2\/media?parent=28"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}