SQL 92 并未定义 AutoID 实现标准,导致不同的数据库使用不同的实现,特此整理之,方便查询使用。
---------------------------------------------------------------
SQLite:
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
MySQL:
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
PostgreSQL:
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
SQL Server:
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
Oracle:
Oracle 在通过 Sequnece 实现 AutoID,当 Drop table 时,触发器同时被 drop,但是 sequence 依然残余,需要手动清除。
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
SQL 92 并未定义 AutoID 实现标准,导致不同的数据库使用不同的实现,特此整理之,方便查询使用。
---------------------------------------------------------------
SQLite:
MySQL:
PostgreSQL:
SQL Server:
Oracle:
Oracle 在通过 Sequnece 实现 AutoID,当 Drop table 时,触发器同时被 drop,但是 sequence 依然残余,需要手动清除。