篇一：Mysql 5.1 注册码
Mysql-front 5.1注册码
bhaaAThangemMkaz2tQhq3/f7dZ7
Vj29WeGHjuupj/AhYqymjAuokhYi
X1T/fG+q1yR22PdcEP39dxU3ovEo
lLLzwIZlQr9oJYwUf5eG4x5e1bMP
nfIaIl8reszQPHFNbrxBjCVrBEXL
TyBLehxzUpVI672t3LjX8q4ytCRC
ezcoZQfMAc0DulJzNREbwlcf0Rco
N0zW3ojBUxGsplBBZZPrD7/bPhkM
rjtS8Bxym+HeV1TJDTXuiL8QLg==
======================================
fSbC9xxy7ga57DOrLz9mMqYSFx8S
OIWiOBI61uJ562GINVTVNBDaGBIl
Cuni0a1iUAF88I6zrHzH9Wzcv4h+
h3wTGgOX8mYgN0jEEOmzI1DLx0DJ
8t94hUJ5O0I99Ts6iqvHhw24jYfI
h++JG/BzVLnaSDbNdqH9iYbXZ2Pc
eFZAZe6hzPQ9DREtkEvg7rAul/Fw
ZptCP1WFfKkfgviwY8i67NucJe2L
UTZFKoX5MGSuP9GGJnouQg/P1SII
3PCKXGoUv0hBoTiMLXBlJWpaNg==
=============================================
0W01VaFQPp/XRYgXjOFSUY7hZ5Cc
W9f35KH4bym2jmhYygsHyNsr47Hs
7OBjd7QH+ALAKqZdDAh/AfG3V/8Q
his64uZEhglY8B8yu5PvN49tOO05
XG7Qyz3skOK3An9Zoc/xSA1fLGeq
PioqBj/khHWF1LK0lBi00LOLFXzs
oQtoMi1Ol+Ehxz8URH3kQqN09raw
iM7DrTxZe1oVoOjTPDerwPOLULI1
6EnbdBu92YSk0tYQw0BmVss2G6ak
GjaDrPWrDWP3uip0OOX4UXNggQ==
===============================================
H4nLHG3xsjy5l4QMEsSpaYAyggPp
9OdFDMG0Y1XM7VqTyg+GAAm8V/eP
9zuAwQ5/9tA8GQeOlavXxIDkMsY7
I4UAy4LmhUU2vLtEkgjtMhSd3nFT
OGe2bOmGvoMCPts/1eQx5YFMet9K
AjkZPI1BR8/fm7Mb0bQOPeJQyilC
T1/4k4MfqnQkub06+ADZ7pg3WdkC
jneqAVvKPaM2Kf55cGDsLmo3Xxck
ZHpzPKJDISjEQ+qFadS8Z9Ao0HHK
31JWyvw0Qr/9d0Ku10+W6DrhZw==
=================================================
DZaNXFw2rfRrF3xlukPGGiilkurQ
r7vKuSPCUEdAoRWRJmjnADY0Ink3
Nr9qD3CM5+v9PYJ4uf/b9jShtlYH
KV16XPA+On7CjH8zqxywbz2ci85i
f0va/I0DOvGhpsww1jAJCJWC4A+z
ZjTMzA0+SEQcKyHzOUe89eA+c/Gq
FZBmitn5u602wlMj2KtvMSN8EgSc
wDVxI+FSi0U/b89fRaUMJRbUadm0
uZHKMPdlaykMQPwZFN8G561OFCU/
rbFQlatd0JFPnLKxjNsjva04LQ==
===============================================
hFeWdc8oboH/QwzaaLhrH6CgRo6g
nBXqa0bjHJdEYTIzMdqnkEBvygf+
xJeO2zRqajhnH+S1wZWeNUwXLwZm
KvS8LCvwCf1WBqzsRMuDOTQnac5d
RGf80G986szBG8kzkhKjC4Bx3uLy
NomiYSHrGBoDacd5wPCqFMoTsaMC
CjVMabK/JyQyAeuULOf8lW0WiXTo
TKH7k1yGW6plaQKWGIqBZuYlYk5H
tFm8hdKXaxbeiiREFl7ni1G9lP7j
1Gdf/cmb+fq2sKrSgZyLEjQLFA==
===============================================
Y2CjWsyI23Fa0G1pban8ep83zQAI
7mERztK7a3ZufX0LWeAe/y50DURN
kOOlakZ0dgkoipf/6KsNEEm2aptm
L3/dXG1jKphojzSwNsS4PHY4qGKA
9vHBEAsDLlwGrLFfmdtKOCrgNG6V
ab7clt+yRFuxctwefegNu02YdlGC
wEKI2MP9QcMXl/aFLkFsz3mBFn1t
YZtjYFswD+7zJ6KETy1cRK0TG/UK
/6GoBQtjLIeCjNBbrEWvOm6XunsO
jCaOhBeccOe3lIUCbJEwSFKAGA==
=============================================
3AFJhTfHVl0MBUFC1NEgO34cyEqR
saJhnLE8X1K0OU5wU630QIlLyAiu
pMGYcSoTEanqEaBvKiXFfMvqbTM+
X87dmWn6bicol0G9APDw1GKO4A4g
Zyc8z47uRSNgqD9moJGFIdZZ+l1b
+/PCg5MKBBhDhc6VDBKJ3hdVTu6L
sW3+fY+9awZvyMMrXNu3STU0z0TX
kHVOuMI+XqKeywPGEClGO/U5vgN7
DbL2xQm0Czm89V3fPnY+03gVOkP2
dvBKP4EqwgCXuxJVDEbC8T0bPQ==
=============================================
SoydMqMl+/Gpf41SeCYSamtq3urK
wqREsSLloXTdR1DoEd6sFEtxWH+0
w/nC12MfI+TzlhOuvit3bqOzUSrq
XTPipT1EA1YfelWllo3inkHWZ8Bd
IG4b/GCULr4ufAKEtZnyXVHeUPoo
/HCkWPViDUwQUbQqZhcu7baPDnAo
fGQlW5++dTXq3yIZTxNs8tpffgEk
5oemtUyJhXaAEas6KQKw/vEFLPho
48B3tuL31SNvluTSp3O3y8qZvSEV
h3GE09Cp7E4SWKkv6rB9VG8Vcg==
===============================================
Xzlv+2HZXpuIUhAUGVYmjhw6ncp9
b7qlOIwQa4BiPlhJl61ma2fUW1s4
BvNSzx0WgiHGB86X6VZ1ix3bXZop
eq4MxQFHKtaLj60Y6jduOX8Id9Is
oBIKLLkuRijSbZJpBxIqHLrz+2C/
nym1n8XbWYagYJ1z4OqNxjkrCGfW
LoSPC9jAtivGSk3T5lDsUzh6MEqF
bSd6Bjce5tqDgX9AV0DM3icFg3dF
/u9XXp+72DOCT9FStV01UwID6L/O
zzokhH37OQL8irSbjE1FdGW+TQ==
==========================================
BJNZHBPeVX4GKH3AbulBcezga945
qNEKaHM8PpixioQLO0rZ57tUUQ7l
jkWF/5Vh6pWVSJTmNhM54CkFDq3a
M6EVzfPJT00+YS66mmQe4FI85zaj
cvyNyiaKqBh8XjwxXhFs6oHjYJJ4
MAWRTTvOVXDH29E7J30UQkz4qFWD
0445Aj0clJCfu4WAmGq7TmAWF8H2
g+k5VUTx8aBnRS/WVMG3iyryv+3h
W2S4LjfsnF1Zsaf4D4N9p5Uqr2rI
Lvhaj80tbxjTja+MLVhNr4GURQ==
=================================================
Lv/+h44wqgNXFicAJPjLZFqwpCoF
mnn2JvfPTtQ9kEX51XdLNImcH6Pe
bKp1KUMMGaUWSA5/NRMqqmoVaJQm
Fh3B9G2jCyVfYeag+EFRCI/ByCpx
Jg+yvnE4i9NUS1mKuBXD/QR5uEBk
OsiAzv8DgQORN/sbIkjUKX7vwvzG
6QEaDIPaWzKqPV7RIctjkUt4+5Av
r5oBre/6Mg1Q1GIhBftZkD1UtPm3
/3oDrT3o+2SlPNwElOcmypfkMHkk
jAVK5+vfb8lOPKou3lmzUPZPKw==
==============================================
zPH5/yKwB7akS0BMDoMsIRoIA0dN
rE5EB8qSLhyCiwp+oZVZOYm7fH/o
z7odFfCIGuTPHwUOB7r2u6AT1v0a
i0vSNJXevY/dv/EY2hCClIhxTohs
GUE0VLLV3vZJ0+AalJPuXfP3v513
PQgPG0jLLMHoYm2gC0eZU4TCQx0B
r4JJo5Ne0CH9wGfwiPdkIul0NhHU
uQGP78v0FIsTBbQvDuing6q3msxX
GQ+GeVUmshiefNvZ8MzB86ug0PaL
hgtayc9N3lwGEf23C2S/MZW6bQ==
==================================================
pF+PyM1Vz5eTwApjWBBOC8UtZmOV
0xsmgjgvdTLVMXc8pLbhdsDkvMyI
sgBv8WZuftr4FdKRxQVXVr+j5MAi
ai3I9jJ4msA80i5ITzj+UykFuXeJ
M8AB68iTiN80FjoKA1o2aJcjzc1J
ffxHJCavDvlFG7KnfbuM9VjLHIbQ
9lkXTIQX20o6qYOPmPpOG7JqeVLe
H4XZLbTjzJp81h5YY9dVISCKbf01
1Wl6vlh3L1Q1IFSnIfaQpTZwixHw
bJZE8tuy2STl7G17uiqjuvcmdg==
http://blog.csdn.net/luck52yjk/archive/2009/12/02/4921857.aspx
篇二：关于分组序号在MySQL中的实现
好像ORACLE中有相应的函数，可惜在MSSQL 或者MySQL中没有对应的函数。后两者就得用临时表来实现了。
1、表结构以及示例数据。
create table company
(dep char(10) not null,
val1 int unsigned not null
);
insert into company values
('市场部', 26),
('市场部',25),
('市场部',24),
('办公室',16),
('办公室',12),
('研发部',19),
('研发部',11);
2、存储过程
1）、循环实现
DELIMITER $$
CREATE DEFINER=`root`@`%` PROCEDURE `sp_generate_auto`()
BEGIN
declare cnt int default 0;
declare i int default 0;
drop table if exists tmp;
-- Temporary table to save the result.
create temporary table tmp like company;
alter table tmp add num int unsigned not null;
select count(1) as total from (select count(1) from company where 1 group by dep) T into cnt;while i < cnt
do
set @stmt = concat('select dep from company where 1 group by dep ord(本文来自：wwW.xIaocAofanwEn.coM 小草 范文 网:mysql自动序列号)er by dep asc limit ',i,',1 into @t_dep');
prepare s1 from @stmt;
execute s1;
deallocate prepare s1;
set @stmt = NULL;
set @num = 0;
set @stmt2 = concat('insert into tmp select dep,val1,@num := @num + 1 as sequence from company where
dep = ''',@t_dep,''' order by dep asc');
prepare s1 from @stmt2;
execute s1;
deallocate prepare s1;
set @stmt2 = NULL;
set i = i + 1;
end while;
select * from tmp;
set @t_dep = NULL;
END$$
中国返利网 / 汇丰农牧 /
DELIMITER ;
2）、游标实现
DELIMITER $$
中国返利网 / 汇丰农牧 /
DROP PROCEDURE IF EXISTS `sp_generate_auto_cursor`$$
CREATE DEFINER=`root`@`%` PROCEDURE `sp_generate_auto_cursor`()
BEGIN
declare done1 int default 0;
declare a char(10);
declare i int unsigned default 0;
-- Cursor one to get the group total
declare cur1 cursor for select dep from company group by dep;
declare continue handler for 1329 set done1 = 1;
-- Temporary table to save the result.
drop table if exists tmp;
create table tmp like company;
alter table tmp add num int unsigned not null;
open cur1;
while done1 != 1
do
fetch cur1 into a;
if not done1 then
set @i = 0;
begin
篇三：navicat for mysql注册码
Navicat for MySQL 9.1.6 Enterprise + 注册码
2010-12-29 09:35 P.M.
Navicat for MySQL基于Windows平台，为MySQL量身订作，提供类似于MsSQL的用管理界面工具。
Navicat for MySQL 9.1.6 Enterprise 注册码:
yvon
yvon
NAVD-ULQR-YD73-V3BR [貌似要英文版才能激活]
下载: /en/products/navicat_mysql/mysql_overview.html