{"id":106,"date":"2007-07-06T13:05:27","date_gmt":"2007-07-06T11:05:27","guid":{"rendered":"http:\/\/www.hermione.de\/blog\/?p=106"},"modified":"2008-05-12T15:01:05","modified_gmt":"2008-05-12T13:01:05","slug":"mysql","status":"publish","type":"post","link":"http:\/\/blog.hermione.de\/?p=106","title":{"rendered":"mysql client"},"content":{"rendered":"

zur mysql db verbinden<\/h4>\n\n\n\n
\n
mysql -h host -u username -p<\/code><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
mysql befehle<\/h4>\n
SHOW DATABASES<\/strong> zeigt Datenbanken an
\nCREATE DATABASE uniques<\/strong> Anlegen einer DB
\nUSE uniques<\/strong> zur DB „uniques“ wechseln
\nSHOW TABLES<\/strong> Tabellen der ausgewaehlten DB
\nDESCRIBE TABLE uniques<\/strong> Spalten und Spaltentypen der Tabelle „uniques“<\/p>\n
select<\/h4>\n
LIKE<\/strong> „%string%“
\nGROUP BY<\/strong>
\nORDER BY<\/strong> Sortier-Reihenfolge
\nDESC | ASC<\/strong> absteigend oder aufsteigend
\nLIMIT<\/strong> Anzahl der ausgegebenen Datens\u00e4tze
\nSELECT * FROM uniques WHERE name LIKE „%hund%“;<\/em>
\nSELECT count(*),owner FROM uniques;<\/em>
\nSELECT name FROM uniques WHERE id=101;<\/em>
\nSELECT DISTINCT age FROM adressen;<\/em>
\nSELECT itemtype,count(*) FROM uniques WHERE welt=6 AND aktion=0 GROUP BY itemtype;<\/em><\/p>\n
mehrere Tabellen verknuepfen<\/h4>\n
SELECT auto.name, adressen.name FROM adressen,autos WHERE autos.id=adressen.auto_id AND adresse.id=222;<\/em><\/p>\n
insert und update<\/h4>\n
INSERT INTO uniques (name, owner) VALUES („Roter Himmel“, „Sabine“);<\/em>
\nINSERT INTO uniques SET name=“Roter Himmel“, owner=“Brigitte“;<\/em>
\nUPDATE uniuqes SET name=“Roter Himmell“ WHERE owner=“Brigitte“;<\/em><\/p>\n
mysql befehle auf der commandline ausfuehren<\/h4>\n\n\n\n
\n
mysql < create_table.sql<\/code><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
datei mit mysql anweisungen<\/em><\/h4>\n\n\n\n
\n
#create_table.sql\r\nCREATE TABLE uniques\r\n(\r\n   id INT AUTO_INCREMENT NOT NULL,\r\n   name VARCHAR(128),\r\n   owner VARCHAR(128),\r\n   img VARCHAR(256),\r\n   descr TEXT,\r\n   date TIMESTAMP,\r\n   PRIMARY KEY (id)\r\n);\r\n\r\nINSERT INTO uniques (name,owner) VALUES (\"Mauseloch\", \"Katze\");\r\nINSERT INTO uniques (name,owner) VALUES (\"Hundeknochen\", \"Katze\");<\/code><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"
zur mysql db verbinden mysql -h host -u username -p mysql befehle SHOW DATABASES zeigt Datenbanken an CREATE DATABASE uniques Anlegen einer DB USE uniques zur DB „uniques“ wechseln SHOW TABLES Tabellen der ausgewaehlten DB DESCRIBE TABLE uniques Spalten und Spaltentypen der Tabelle „uniques“ select LIKE „%string%“ GROUP BY ORDER BY Sortier-Reihenfolge DESC | ASC […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"_links":{"self":[{"href":"http:\/\/blog.hermione.de\/index.php?rest_route=\/wp\/v2\/posts\/106"}],"collection":[{"href":"http:\/\/blog.hermione.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.hermione.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.hermione.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.hermione.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=106"}],"version-history":[{"count":0,"href":"http:\/\/blog.hermione.de\/index.php?rest_route=\/wp\/v2\/posts\/106\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.hermione.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.hermione.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=106"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.hermione.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}