SQL

SQL

1. COMANDOS

   • SELECT
     • EJEMPLO
       • SELECT column1, column2
   • INSERT
     • EJEMPLO
       • INSERT INTO table (column1, column2, column3) VALUES (value1, value2, value3);
       • INSERT INTO table_name VALUES (value1, value2, value3, ...);
   • DELETE
     • EJEMPLO
       • DELETE FROM table_name WHERE condition;
   • UPDATE
     • EJEMPLO
       • DELETE FROM table_name WHERE condition;

2. OPERADORES

   • AND
     • EJEMPLO
       • SELECT column1, column2, ... FROM table_name WHERE condition1 AND condition2 AND condition3 ...;
   • OR
     • EJEMPLO
       • SELECT column1, column2, ... FROM table_name WHERE condition1 OR condition2 OR condition3 ...;
   • LIKE
     • EJEMPLO
       • SELECT column1, column2, ... FROM table_name WHERE columnN LIKE pattern;
   • IN
     • EJEMPLO
       • SELECT column_name(s) FROM table_name WHERE column_name IN (value1, value2, ...);
   • BETWEEN
     • EJEMPLO
       • SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2;
   • SELECT TOP
     • EJEMPLO
       • SELECT TOP number|percent column_name(s) FROM table_name WHERE condition;

Bilder und Dateien der Mindmap