DROP TABLE numbered_cia;
CREATE TABLE numbered_cia
(counter INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY
,name VARCHAR(50)
,region VARCHAR(60)
,area DECIMAL(10,0)
,population DECIMAL(11,0)
,gdp DECIMAL(14,0)
);
INSERT INTO numbered_cia (name, region, area,
population,gdp)
SELECT name, region, area, population, gdp
FROM gisq.cia;
SELECT * FROM numbered_cia
set @n=0 ;SELECT @n := @n+1 AS rownum, adresse ,rubrik FROM mail_adressen limit 10;
Linux/MySql/rownum (last modified 2008-11-04 07:00:24)
