Mega Code Archive

 

Categories / MySQL / Procedure Function

 

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;