-- 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;
|