/SQL/Mysql select all columns and specific fields as

Mysql select all columns and specific fields as

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

-1

Source: stackoverflow.com

Similar codes

0 vote243 views2 answers
How to know the character set of an oracle databes
SQL
1 vote253 views1 answer
Alter constraint in sql
SQL
1 vote290 views1 answer
Drop colum oracle 18c
SQL
1 vote240 views1 answer
Pgsql sum switch case
SQL
0 vote237 views2 answers
Update all columns in one update
SQL
0 vote233 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote246 views1 answer
Suse status MySQL
SQL
0 vote265 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote256 views1 answer
Postgresql stored procedure update table values
SQL
0 vote255 views1 answer
Where date major today mysql
SQL

Share