/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 vote203 views1 answer
Copied text from internet not inserting in mysql
SQL
1 vote187 views1 answer
Round function in sql oracle
SQL
0 vote201 views1 answer
Code to move ietms from one table to another myswl
SQL
0 vote179 views1 answer
Mysql cdn link
SQL
7 votes165 views1 answer
Mysql load data infile csv
SQL
0 vote177 views1 answer
Name '_mysql' is not defined
SQL
0 vote196 views4 answers
User defined function sql
SQL
0 vote230 views1 answer
Sqlite get date only
SQL
0 vote138 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
0 vote187 views1 answer
Codeigniter 3 get best-selling products
SQL

Share