在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表中是否存在特定列，以確保正確處理不存在的列。