LAST_INSERT_ID()函数来获得刚刚 INSERT 的值,也就是相当于 ORACLE^的 SEQUENCE. NETVAL 也
就是 INSERT 操作+SELECT 操作获得一个自动编号。
mysql> CREATE TABLE MOCHA_BE_SEQUENCE(IDIGINT NOT NULL PRIMARY K EY
AUTO_INCREM
ENT);
Query OK, 0 rows affected sec)
mysql> INSERT INTO MOCHA_BE_SEQUENCVALUES(NULL);
Query OK, 1 row affected sec)
mysql> SELECT LAST_INSERT_ID();
Oracle 至 U mysql 转换的问题总结....................................................................1
常用字段类型区别................................................................................1
个别语句写法区别................................................................................1
常见的函数替换..................................................................................1
MySQL 转换 Oracle 的七大注意事项................................................................23
序列处理....................................................................................25
Mysql 中文乱码问题完美解决方案.................................................................28
mysql 日期和字符相互转换......................................................................32
常用脚本....................................................................................33
时间类型 default 转换:.......................................................................33
启动 mysql..................................................................................33
表分区处理:.................................................................................35
修改主键:..................................................................................37
mysql:表注释和字段注释.......................................................................37
建表时控制主键的起点【 auto_increment=1001 】:................................................38
不控制主键的起点.............................................................................38
显示表的结构:...............................................................................38
创建临时表: ( 建立临时表 zengchao)...........................................................38
从已经有的表中复制表的结构.....................................................................38
复制表......................................................................................38
对表重新命名.................................................................................38
修改列的类型.................................................................................39
Mysql 区分大小写.................................................................................41
This fun ctio n has none of DETERMINISTIC, NO SQL 解决办法..................................42
1 row in set sec)
mysql> INSERT INTO MOCHA_BE_SEQUENCVALUES(NULL);
Query OK, 1 row affected sec)
mysql> SELECT LAST_INSERT_ID();
+-----------------+
| LAST_INSERT_ID() |
评论1
最新资源