Mysql Kompakt

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);