脚踏祥云

导航

sql 添加数据返回添加Id

string insertSql = "Insert into b_treatise(userId,treatiseTitle,publicationName,publishDate,author,attachment,FundingNum,ImpactFactor,ReferenceNum) values "
                + "('" + userId + "','" + treatiseTitle + "','" + publicationName + "','" + publishDate.ToString() + "','" + author + "','" + attachment + "','" + FundingNum + "','" + ImpactFactor + "','" + ReferenceNum + "');select last_insert_id() as id";
 

select last_insert_id() as id

posted on 2012-03-31 10:17  脚踏祥云  阅读(273)  评论(0编辑  收藏  举报