Go Back   CodingForums.com > :: Server side development > MySQL
Reload this Page handle nonexisting columns

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 03-08-2009, 08:42 AM   PM User | #1
BubikolRamios
Senior Coder

 
Join Date: Dec 2005
Location: Slovenia
Posts: 1,876
Thanks: 114
Thanked 76 Times in 76 Posts
BubikolRamios is on a distinguished road
handle nonexisting columns
Code:
select
IFNULL(t.AB,t.EN) as L
FROM
table t
EN column exists.
This is ok if t.AB exists, need it to work even if it does not exists, like:

Pseudocode:
Code:
select
IFNULL_ERROR(t.AB,t.EN) as L
FROM
table t
Is there something like that ?
BubikolRamios is offline   Reply With Quote
Old 03-08-2009, 04:34 PM   PM User | #2
guelphdad
Super Moderator


 
guelphdad's Avatar
 
Join Date: Mar 2006
Location: St. Catharines, Ontario Canada
Posts: 2,629
Thanks: 4
Thanked 147 Times in 138 Posts
guelphdad will become famous soon enoughguelphdad will become famous soon enough
no, if you try to select from a column that doesn't exist in the table you will get an error.
guelphdad is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


« Previous Thread | Next Thread »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:53 AM.
Advertisement
Log in to turn off these ads.