里创建自增的列应该用什么关键字声明

<script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> CREATETABLEanimals(idmediumintnotnullauto_increment,
namechar(30)notnull,
primarykey(id));