About SW-Quality Safety SW-Entwicklung UML Nachschlagen Programme
.NET
JAVA
HTML http
XML
SQLXML
Datenbanken
CVS
SQL
SQL: ALTER TABLE SQL: CREATE TABLE SQL: Benutzer anlegen SQL: Insert / Update / Delete
 
SQL: Insert / Update / Delete
 

    INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
           [INTO] tbl_name [(col_name,...)]
           VALUES (expression,...),(...),...

or  INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
           [INTO] tbl_name [(col_name,...)]
           SELECT ...

or  INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
           [INTO] tbl_name
           SET col_name=expression, col_name=expression, ...
 

UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
    SET col_name1=expr1, [col_name2=expr2, ...]
    [WHERE where_definition]
    [LIMIT #]
 
 

DELETE [LOW_PRIORITY] FROM tbl_name
    [WHERE where_definition]
    [LIMIT rows]
 

 

 
©; created Mon Aug 07 22:31:53 CEST 2006; eMail