Mysql Kompakt: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Zeile 8: | Zeile 8: | ||
*desc my_table; | *desc my_table; | ||
=Werte in Tabelle einfügen= | =Werte in Tabelle einfügen= | ||
− | *insert into my_table values(11, 127457, 114, 7582, 5.95); | + | *insert into my_table values(11,127457,114,7582,5.95); |
*insert into my_table values(12,348619,152,23820,6.83); | *insert into my_table values(12,348619,152,23820,6.83); | ||
+ | *insert into my_table values(13,361515,151,31414,8.69); | ||
+ | *insert into my_table values(14,408348,200,36885,9.3); | ||
+ | =Wert in einer Reihe ändern= |
Version vom 13. August 2020, 10:11 Uhr
Datenbank erstellen
- create database my_db;
In Datenbank wechseln
- use my_db;
Tabelle erstellen
- create table my_table (kw int(4), tests int(16), labor int(16) , postiv int(16), prozent float);
Beschreibung der Tabelle anzeigen
- desc my_table;
Werte in Tabelle einfügen
- insert into my_table values(11,127457,114,7582,5.95);
- insert into my_table values(12,348619,152,23820,6.83);
- insert into my_table values(13,361515,151,31414,8.69);
- insert into my_table values(14,408348,200,36885,9.3);