narozeniny.sql

Tabulka narozenin s pohledem

MySQL

CREATE TABLE `clovek` (
   `id` int(11) NOT NULL auto_increment,
   `jmeno` varchar(60) collate utf8_czech_ci NOT NULL,
   `narozen` date NOT NULL,
   PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
 
 
INSERT INTO `clovek` VALUES (1, 'Alena', '2003-06-15');
INSERT INTO `clovek` VALUES (2, 'Franta', '2001-06-14');
INSERT INTO `clovek` VALUES (3, 'Pavel', '2002-12-10');
INSERT INTO `clovek` VALUES (4, 'Jana', '2000-08-16');
INSERT INTO `clovek` VALUES (5, 'Jindra', '2005-03-12');
INSERT INTO `clovek` VALUES (6, 'Helena', '2004-02-29');
INSERT INTO `clovek` VALUES (7, 'Anna', '1950-04-18');
 
CREATE VIEW narozeniny AS
   SELECT jmeno,
      narozen,
      datediff(
         date_add(narozen, INTERVAL timestampdiff(
         YEAR, narozen, date_sub(now(), INTERVAL 1
         DAY)) +1 YEAR), now()) AS zbyva,
      timestampdiff(YEAR, narozen, date_sub( now( ) , INTERVAL 1 DAY ))+1 AS vek
FROM clovek;

Neformátovaný

Přidáno: 15.6.2013
Expirace: Neuvedeno

Autor: Kit