TechArena Community

TechArena Community (http://forums.techarena.in/)
-   Software Development (http://forums.techarena.in/software-development/)
-   -   MySQL query select all columns but exclude specific. (http://forums.techarena.in/software-development/1222729.htm)

RSeven 29-07-2009 08:25 PM

MySQL query select all columns but exclude specific.
 
I have a query but I am not sure how to do this/
MySQL query select all columns but exclude specific.
In MySQL I want to Fire a query that will give us a result with selecting all the columns but exclusing a specific one which is mentioned.

I mean to say something like "select * from ... except ...."
Is this possible?

Please help me with this kind of MySQL query.

sligh 29-07-2009 08:29 PM

Re: MySQL query select all columns but exclude specific.
 
To select all columns simply use
Code:

SELECT column_name(s)
FROM table_name

&

Code:

SELECT * FROM table_name
learn here: http://www.w3schools.com/sql/sql_select.asp

wazzeledozzle 29-07-2009 09:23 PM

Re: MySQL query select all columns but exclude specific.
 
Simple Retrieval: Returning All Columns

Code:

/*
mysql> CREATE TABLE Student (
    ->    StudentID INT NOT NULL PRIMARY KEY,
    ->    Name      VARCHAR(50) NOT NULL
    -> )TYPE = InnoDB;
Query OK, 0 rows affected, 1 warning (0.08 sec)

mysql> /* Insert data for testing */
mysql> INSERT INTO Student (StudentID,Name) VALUES (1,'Joe Yin');
Query OK, 1 row affected (0.06 sec)

mysql> INSERT INTO Student (StudentID,Name) VALUES (2,'Cory But');
Query OK, 1 row affected (0.02 sec)

mysql> INSERT INTO Student (StudentID,Name) VALUES (3,'JJ Harvests');
Query OK, 1 row affected (0.04 sec)

mysql> /* Real command */
mysql> SELECT * FROM Student;
+-----------+-------------+
| StudentID | Name        |
+-----------+-------------+
|        1 | Joe Yin    |
|        2 | Cory But    |
|        3 | JJ Harvests |
+-----------+-------------+
3 rows in set (0.03 sec)


*/

/* Prepare the data */
DROP TABLE Student;

CREATE TABLE Student (
  StudentID INT NOT NULL PRIMARY KEY,
  Name      VARCHAR(50) NOT NULL
)TYPE = InnoDB;


/* Insert data for testing */
INSERT INTO Student (StudentID,Name) VALUES (1,'Joe Yin');
INSERT INTO Student (StudentID,Name) VALUES (2,'Cory But');
INSERT INTO Student (StudentID,Name) VALUES (3,'JJ Harvests');
 
/* Real command */
SELECT * FROM Student;

I hope this helps you.

GunPoint 29-07-2009 09:26 PM

Re: MySQL query select all columns but exclude specific.
 
You can also use the information_schema to give you information about the columns in the table.
http://dev.mysql.com/doc/refman/5.0/...on-schema.html

This is a good way to retrieve data.


All times are GMT +5.5. The time now is 07:16 PM.