Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



MySQL query select all columns but exclude specific.

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 29-07-2009
Member
 
Join Date: May 2008
Posts: 34
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.

Reply With Quote
  #2  
Old 29-07-2009
Member
 
Join Date: Apr 2008
Posts: 30
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
Reply With Quote
  #3  
Old 29-07-2009
Member
 
Join Date: May 2008
Posts: 37
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.
Reply With Quote
  #4  
Old 29-07-2009
Member
 
Join Date: Apr 2008
Posts: 22
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "MySQL query select all columns but exclude specific."
Thread Thread Starter Forum Replies Last Post
Query specific DNS server? Sachit Technology & Internet 4 02-12-2011 02:06 AM
Select unique columns from a record set Madhuchhanda Software Development 6 12-05-2010 11:31 PM
Query for columns in oracle database Gerri Windows Software 4 10-02-2010 08:27 PM
Turn on MySQL query cache to speed up query performance DMA2Superman Software Development 3 07-07-2009 10:26 AM
Exclude one person from specific domain policy Matt Windows Server Help 4 05-03-2008 10:43 PM


All times are GMT +5.5. The time now is 09:54 PM.