Mysql an Grafana: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
| Zeile 5: | Zeile 5: | ||
**create database covid19; | **create database covid19; | ||
==Tabellen anlegen== | ==Tabellen anlegen== | ||
| − | + | *use covid19; | |
| − | + | *create table statistik (datum date, best_faelle int, genesens int, verstorbene int); | |
=User anlegen und Rechte geben= | =User anlegen und Rechte geben= | ||
| − | + | *create user 'covid-admin'@'localhost' identified by 'oimel'; | |
| − | + | *grant all privileges on covid19.* to 'covid-admin'@'localhost'; | |
| − | + | *flush privileges; | |
| + | =Tabelle anzeigen= | ||
| + | *desc statistik; | ||
| + | <pre> | ||
| + | +-------------+---------+------+-----+---------+-------+ | ||
| + | | Field | Type | Null | Key | Default | Extra | | ||
| + | +-------------+---------+------+-----+---------+-------+ | ||
| + | | datum | date | YES | | NULL | | | ||
| + | | best_faelle | int(11) | YES | | NULL | | | ||
| + | | genesens | int(11) | YES | | NULL | | | ||
| + | | verstorbene | int(11) | YES | | NULL | | | ||
| + | +-------------+---------+------+-----+---------+-------+ | ||
| + | 4 rows in set (0.00 sec) | ||
| + | </pre> | ||
| + | =CSV Datei importieren= | ||
Version vom 19. Juni 2020, 09:16 Uhr
Datenbank anlegen
- mysql -u root -p
In Mysql
Datenbankl anlegen
- create database covid19;
Tabellen anlegen
- use covid19;
- create table statistik (datum date, best_faelle int, genesens int, verstorbene int);
User anlegen und Rechte geben
- create user 'covid-admin'@'localhost' identified by 'oimel';
- grant all privileges on covid19.* to 'covid-admin'@'localhost';
- flush privileges;
Tabelle anzeigen
- desc statistik;
+-------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------+------+-----+---------+-------+ | datum | date | YES | | NULL | | | best_faelle | int(11) | YES | | NULL | | | genesens | int(11) | YES | | NULL | | | verstorbene | int(11) | YES | | NULL | | +-------------+---------+------+-----+---------+-------+ 4 rows in set (0.00 sec)