/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 vote141 views1 answer
Check if due date is less than todays date sql
SQL
7 votes172 views1 answer
Sql server convert string to date
SQL
0 vote191 views1 answer
Sqlite explain plan
SQL
12 votes202 views5 answers
Rename table in mysql
SQL
1 vote243 views2 answers
Mysql SELECT
SQL
0 vote171 views1 answer
Database springboot
SQL
0 vote184 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
2 votes193 views3 answers
Sql delete duplicate
SQL
9 votes194 views3 answers
Find all tables with column name
SQL
2 votes141 views5 answers
Alter table primary key postgresql
SQL

Share