CODEWITHSUNDEEP
mysqlselect
Jordashiro
Jordashiro

Reputation: 805

SELECT command in mysql

I was wondering if there is a way to do something like selecting all without ... some columns here

something like SELECT */column1,column2 , is there a way to do this ? I just need to output something like

column1 , column2 ( from another table ) , here all other columns without column1 ( or something to make the select skip the first few columns)

EDIT: The thing is that i need this to be dynamic , so i cant just select what i don't know. I never know how many columns there will be , i just know the 1st and the 2nd column

EDIT: here is a picture http://oi44.tinypic.com/xgdyiq.jpg I don't need the second id column , just the last column like i have pointed.

Upvotes: 0

Views: 152

Answers (6)

Starx
Starx

Reputation: 79049

If you need to combine records from multiple tables, you need to find a way to relate them together. Primary Keys, Foreign Keys, or anything common among this.

I will try to explain this with a sql similar to your problem.

SELECT table1.id, table2.name, table1.column3, table1.column4 
FROM table1
INNER JOIN table2 On table2.commmonfield = table1.commonfield

Upvotes: 1

Craig Trombly
Craig Trombly

Reputation: 464

Start building custom views, which are geared aorund saving developers time and encapsulating them from the database schema.

Upvotes: 2

Hasteur
Hasteur

Reputation: 462

The SQL language lets you either select a wildcard set of columns or enumerated single columns from a singular table. However you can join a secondary table and get a wildcard there.

SELECT
  a.col1,
  b.*
FROM
  table_a as a
JOIN table_b as b ON (a.col5 = b.col_1)

Upvotes: 0

DanRedux
DanRedux

Reputation: 9359

Oh, so select all but certain fields. You have two options.

One is a little slow.. Copy the table, drop the fields you don't want, then SELECT * The other is to build the field list from a subquery to information_schema or something, then remove occurrences of 'field_i_dont_want' in that list.

SELECT ( SELECT THE TABLES YOU WANT AND CONCAT INTO ONE STRING ) FROM TABLE

Upvotes: 1

petervaz
petervaz

Reputation: 14205

You either select all columns (*) or especify the columns you want one by one. There is no way to select 'all but some'.

Upvotes: 0

Teja
Teja

Reputation: 13544

If you have 'n' columns in your table as in Col1,Col2,Col3....Coln you can select whatever columns you want to select from the table.

SELECT Col1,Col2 FROM YOURTABLE;

Upvotes: 0

Related Questions