ALTER TABLE表AUTO_INCREMENT = $ x [英] ALTER TABLE table AUTO_INCREMENT = $x

问题描述

我想执行此查询，但是它不起作用，我也不知道为什么:

i would to execute this query but it doesn't work and i don't know why :

$query = mysqli_query($connexionUser, "ALTER TABLE creatik AUTO_INCREMENT = '$i'");

我检查了我的var，还可以. 如果可以帮助您了解问题所在，则在作为主键的id列上设置自动递增.

i check my vars and there are okay. Auto increment is set on a id column who is primary key if it can help to understand what's wrong.

感谢您来看看:)

推荐答案

AUTO_INCREMENT需要一个整数.可能引号已被删除，请尝试将其删除.

AUTO_INCREMENT expects an integer. It's possible that the quotes are throwing it off, try removing them.

这篇关于ALTER TABLE表AUTO_INCREMENT = $ x的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！