在mySQL中确定列中的列存在

如果存在（从信息_schema.columns select * * where table_name ='prefix_topic'和column_name ='topor_last_update'） 开始 alter表`prefix_topic`添加'topor_last_update` dateTime not null; 更新`prefix_topic`设置`topic_last_update` =`topic_date_add`; END;seems to fail.

However, a reliable solution involves using the SHOW COLUMNS command:

IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS 
           WHERE TABLE_NAME='prefix_topic' AND column_name='topic_last_update') 
BEGIN 
ALTER TABLE `prefix_topic` ADD `topic_last_update` DATETIME NOT NULL;
UPDATE `prefix_topic` SET `topic_last_update` = `topic_date_add`;
END;

PHP实现

此方法允许您迅速检查MySQL表中是否存在特定列，以确保正确处理不存在的列。