/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 vote288 views1 answer
Run mssql server terminal
SQL
2 votes324 views1 answer
Oracle find constraints referencing a table
SQL
5 votes290 views1 answer
Minecraft java port number
SQL
8 votes284 views1 answer
Oracle all_source package body
SQL
20 votes295 views1 answer
Sql change column types
SQL
0 vote285 views1 answer
Dump multiple tables mysql
SQL
14 votes304 views1 answer
Excel
SQL
0 vote316 views1 answer
Mysql edit trigger
SQL
0 vote288 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
7 votes327 views2 answers
How to create index mysql
SQL

Share