xxxxxxxxxx
SELECT * FROM `table_name`;
SELECT `col1`,`col2` FROM `table_name`;
SELECT `col1 as name`,`col2 as email` FROM `table_name`;
SELECT * FROM `table_name` WHERE id = '1';
xxxxxxxxxx
SELECT * FROM table;
SELECT * FROM table1, table2;
SELECT field1, field2 FROM table1, table2;
SELECT FROM WHERE condition
SELECT FROM WHERE condition GROUP BY field;
SELECT FROM WHERE condition GROUP BY field HAVING condition2;
SELECT FROM WHERE condition ORDER BY field1, field2;
SELECT FROM WHERE condition ORDER BY field1, field2 DESC;
SELECT FROM WHERE condition LIMIT 10;
SELECT DISTINCT field1 FROM
SELECT DISTINCT field1, field2 FROM
xxxxxxxxxx
SELECT
`nachname` , `vorname`
FROM testadressen
WHERE vorname = 'Fischer'