我试图在我的phpmyadmin中为数据库表创建一个新列,但是我一直在下面获取它。我也注意到我无法更改下拉列表中的移动列字段为全灰色

预览是

ALTER TABLE `jobs` ADD `job_title` VARCHAR(255) NOT NULL AFTER ;


我不久后收到此错误

   Notice in ./libraries/classes/CreateAddField.php#152
 Undefined index: after_field

Backtrace

./libraries/classes/CreateAddField.php#113: PhpMyAdmin\CreateAddField->setColumnCreationStatementSuffix(
integer 0,
integer -1,
boolean false,
)
./libraries/classes/CreateAddField.php#302: PhpMyAdmin\CreateAddField->buildColumnCreationStatement(
integer 1,
boolean false,
)
./libraries/classes/CreateAddField.php#536: PhpMyAdmin\CreateAddField->getColumnCreationStatements(boolean false)
./tbl_addfield.php#69: PhpMyAdmin\CreateAddField->tryColumnCreationQuery(

最佳答案

您需要添加名称列,之后再添加

ALTER TABLE `jobs` ADD `job_title` VARCHAR(255) NOT NULL AFTER yourcolumnName

07-26 09:42