MySQL Forums
Forum List  »  German

Re: Spaltenreferenz
Posted by: Thomas Wiedmann
Date: September 13, 2012 07:11AM

Hallo Jörg,

eventuell helfen Dir VIEWs beim Faulsein. Mit VIEWs können Spaltennamen einen passenden oder einfacheren Namen bekommen.

CREATE TABLE test_table (
 id INT NOT NULL,
 erstes_feld_der_zu_bla INT NOT NULL,
 zweites_feld_der_zu_bla INT NOT NULL, 
 
 PRIMARY KEY (id)
);

INSERT INTO test_table VALUES
( 1, 11, 12 ),
( 2, 21, 22 ),
( 3, 31, 32 );


CREATE VIEW test_table_v AS
SELECT id,
       erstes_feld_der_zu_bla AS feld1,
       zweites_feld_der_zu_bla AS feld2
  FROM test_table;
  
  
SELECT feld1, feld2, feld2-feld1 As diff
  FROM test_table_v
 WHERE id > 0;
+-------+-------+------+
| feld1 | feld2 | diff |
+-------+-------+------+
|    11 |    12 |    1 |
|    21 |    22 |    1 |
|    31 |    32 |    1 |
+-------+-------+------+
3 rows in set (0.00 sec)

mysql>

Grüße
Thomas

Options: ReplyQuote


Subject
Views
Written By
Posted
1695
September 13, 2012 02:33AM
989
September 13, 2012 03:37AM
1062
September 13, 2012 05:57AM
Re: Spaltenreferenz
942
September 13, 2012 07:11AM
827
September 13, 2012 08:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.