Lunetikk's IT Wiki

User Tools

Site Tools

You are here: start » webseite » mysql » basic
Trace:
webseite:mysql:basic

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
webseite:mysql:basic [2014/06/05 15:55] – lunetikkwebseite:mysql:basic [2018/12/20 17:40] (current) – Discussion status changed lunetikk
Line 15: Line 15:
 |  UPDATE  |  updates existing data in a table  | |  UPDATE  |  updates existing data in a table  |
 |  DELETE  |  deletes all records from a table, space for the records remain  | |  DELETE  |  deletes all records from a table, space for the records remain  |
 +
 +===== Basics =====
 +^  Code  ^  Function  ^
 +|  CREATE TABLE Personal (Lastname CHAR(50) Firstname CHAR(50) Rank VARCHAR(30) Salary (INT));  |  Create table  |
 +|  INSERT INTO Personal (Lastname, Firstname) VALUES ('Doe', 'John')  |  Insert in table  |
 +|  UPDATE Personal SET Salary=3200 WHERE Lastname = "Doe";  |  Change the salary of a person with the lastname Doe  |
 +|  DELETE FROM Personal WHERE Lastname = "Doe" AND Firstname = "John";  |  Remove John Doe  |
 +|  DROP TABLE Personal;  |  Remove table  |
 +|  ALTER TABLE Personal ADD Gender CHAR (1);  |  Add a new column Gender  |
 +|  SELECT Lastname, Firstname FROM Personal ORDER BY Lastname;  |  Order the output by lastname  |
 +|  SELECT Rank FROM Personal GROUP BY Rank;  |  Shows the ranks grouped  |
 +|  SELECT COUNT(*) FROM table;  |  Counts all entries  |
 +|  SELECT * FROM table WHERE field LIKE '%text%';  |  Select all columns for a field with the value "text"  |
 +|  SELECT a.name, a.age, b.address FROM table1 a, table2 b WHERE a.id = b.id;  |  You can use this instead of inner join  |
 +
  
 ===== Code examples ===== ===== Code examples =====
-^  Code  ^  What it does  ^+^  Code  ^  Function  ^
 |  SELECT * FROM Table WHERE Cell LIKE 'test'  |  select all rows in Table where Cell contains 'test'  | |  SELECT * FROM Table WHERE Cell LIKE 'test'  |  select all rows in Table where Cell contains 'test'  |
 |  SELECT IdX FROM Table WHERE Cell LIKE '$Var'  |  select IdX from Table where Cell contains variable Var  | |  SELECT IdX FROM Table WHERE Cell LIKE '$Var'  |  select IdX from Table where Cell contains variable Var  |
Line 24: Line 39:
 |  UPDATE `DB`.`Table` SET `Cell1` = '$Var1' WHERE `Table`.`Cell2`='$Var2'  |  update Table Cell2 to Var2 where Cell1 is Var1  | |  UPDATE `DB`.`Table` SET `Cell1` = '$Var1' WHERE `Table`.`Cell2`='$Var2'  |  update Table Cell2 to Var2 where Cell1 is Var1  |
 |  INSERT INTO Table (Cell1, Cell2) VALUES ('Text', '$Var1')  |  add new row into Table with cell1 as Text and Cell2 as Var1  | |  INSERT INTO Table (Cell1, Cell2) VALUES ('Text', '$Var1')  |  add new row into Table with cell1 as Text and Cell2 as Var1  |
 +
 +\\
 +\\
 +~~DISCUSSION:closed~~
webseite/mysql/basic.1401976538.txt.gz · Last modified: 2017/03/01 12:50 (external edit)

Page Tools

Impressum Datenschutz
Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki