Variable Assignment : Variable Assignment « Procedure Function « SQL / MySQL

1. SQL / MySQL
2. Procedure Function
3. Variable Assignment

Variable Assignment

     

-- SET var1=value1, var2=value2, var3=value3 ...

-- SELECT var:=value
-- SELECT 2*7 INTO var
-- SELECT COUNT(*) FROM table WHERE condition INTO var;


CREATE TABLE titles (
  titleID int(11),
  title varchar(100),
  subtitle varchar(100),
  edition tinyint(4),
  publID int(11),
  catID int(11),
  langID int(11),
  year int(11),
  isbn varchar(20),
  comment varchar(255),
  ts timestamp,
  authors varchar(255),
  PRIMARY KEY  (titleID)
);



INSERT INTO titles VALUES (1,'Linux','Installation',5,1,57,2,2000,NULL,NULL,'2005-02-28 13:34:21','Michael'),
                          (2,'Excel',NULL,NULL,2,3,NULL,2000,NULL,NULL,'2005-02-28 13:34:22','David'),
                          (3,'XML',NULL,NULL,1,2,NULL,1997,NULL,NULL,'2005-02-28 13:34:22','Edwards'),
                          (4,'PHP',NULL,NULL,3,6,NULL,2000,NULL,NULL,'2005-02-28 13:34:22','Tom'),
                          (5,'MySQL','',0,3,34,NULL,2000,'','','2005-02-28 13:34:22','Paul'),
                          (6,'Java',NULL,NULL,4,34,NULL,1999,NULL,NULL,'2005-02-28 13:34:22','Tim');




SELECT title, subtitle FROM titles WHERE titleID=1 INTO @mytitle, @mysubtitle;

drop table titles;

   
    
    
    
    
  

Related examples in the same category