Answers for "select a column in mysql"

SQL
0

select from column mysql

/*
* Ex:- Selecting name from customer table
*/

SELECT name FROM customer;

/*
* Ex:- Selecting customer i.d and name from customer table
*/

SELECT id, name FROM customer;
Posted by: Guest on September-09-2021
-1

mysql select all columns and specific fields as

SELECT mytable.*, column20 AS Customer, column11 FROM mytable
-- OR
SELECT column11, column20 AS Customer, mytable.* FROM mytable
Posted by: Guest on May-20-2020

Code answers related to "select a column in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language