ne treba ti stored procedura za to ..
snimis iz excell-a fajl kao csv (comma separated values) i ucitas sa
load data infile
primer:
Code:
LOAD DATA INFILE 'imefajla.csv' INTO TABLE `t1`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;
naravno mozes i tab separated i ...
isto tako mozes da ih exportujes sa
select into outfile u fajl koji posle mozes iz excela da povuces
primer:
Code:
SELECT * INTO OUTFILE 'fajl.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM `t1`;