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
Last revisionBoth sides next revision
webseite:mysql:basic [2014/06/02 10:03] – lunetikkwebseite:mysql:basic [2018/12/20 17:39] – 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:off~~
webseite/mysql/basic.txt · Last modified: 2018/12/20 17:40 by lunetikk

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