mysql select as
snippet in sql

mysql select statement

user4416

SELECT * FROM table_name;

--or

SELECT column1, column2
FROM table_name;

select mysql

user3380

SELECT column_name(s) FROM table_name

mysql select as

user6392

SELECT CustomerName AS Customer, ContactName AS ContactPerson FROM Customers; -- Without spaces
SELECT CustomerName AS Customer, ContactName AS [Contact Person] FROM Customers; -- With spaces

MySQL SELECT

user8710

SELECT select_list
FROM table_name;