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
Next revisionBoth sides next revision
webseite:mysql:basic [2014/05/27 15:04] – lunetikkwebseite:mysql:basic [2014/06/05 15:55] – lunetikk
Line 1: Line 1:
 ====== MySQL Basics ====== ====== MySQL Basics ======
  
-^Code^What it does^+==== Data Definition Language (DDL) ==== 
 + 
 +^^^ 
 +|  CREATE  |  create new objects in db  | 
 +|  ALTER  |  alters / change the structure of the db  | 
 +|  DROP  |  delete objects from the db  | 
 + 
 +==== Data Manipulation Language (DML) ==== 
 + 
 +^^^ 
 +|  SELECT  |  retrieve data from db  | 
 +|  INSERT  |  insert data into a table  | 
 +|  UPDATE  |  updates existing data in a table  | 
 +|  DELETE  |  deletes all records from a table, space for the records remain  | 
 + 
 +===== Code examples ===== 
 +^  Code  ^  What it does  ^
 |  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  |
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