MySQLÄ£ÄâOracleµÄSequenceÁ½ÖÖ·½·¨

<!--
/* Font Definitions */
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:SimSun;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
{font-family:"\@ËÎÌå";
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:ËÎÌå;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:54815324;
mso-list-type:hybrid;
mso-list-template-ids:1437342586 67698705 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-text:"%1\)";
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
Oracle ÖпÉÒÔ´´½¨
Sequence,ÏÂÃæ´´½¨Ò»¸ö
Sequence
 
CREATE SEQUENCE mysequence START WITH 1 INCREMENT BY 10
 
´Ë
SEQUENCEµÄÏÂÒ»¸öÖµ¿ÉÒÔÓÃ
mysequence.nextval»ñµÃ£¬±ÈÈç
 
SELECT mysequence.nextval from
dual.
»òÕß
Insert into table( id, … ) values(
mysequence.nextval, …)
 
MySQL²»Ö§³Ö
Sequence, ¿ÉÒÔÓÃ
stored procedure»ò
functionÄ£Äâ
Oracle Sequence
 
1)     
stored procedure
·½·¨
 
´´½¨Êý¾Ý¿â±í£º
 
create table mysequence
(
      Id
bigint not null auto_increment;
);
 
´´½¨´æ´¢¹ý³Ì£¨Ê¹Óö¯Ì¬
SQL£©£º
 
DELIMITER $$
 
drop PR