/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 vote69 views1 answer
Connection error in mysql workbench
SQL
0 vote97 views1 answer
Load utilities in sql server
SQL
4 votes104 views2 answers
Mysql select where starts with
SQL
0 vote113 views2 answers
Return the number of records in a single table mysql
SQL
0 vote117 views1 answer
Show all mongodb
SQL
2 votes115 views2 answers
Create empty table from existing table
SQL
0 vote120 views1 answer
How to install Firebird
SQL
4 votes102 views1 answer
Psql get sequences
SQL
18 votes105 views4 answers
Foreign key mySql
SQL
0 vote120 views1 answer
Sql update subtract value
SQL

Share