我想使用 phpMyAdmin 中的查询更改评论

发布于 2024-11-16 09:22:17 字数 254 浏览 0 评论 0原文

我有一个名为 Phase 的表，其中包含以下字段。身份证、姓名。我想使用查询更改其评论。

ALTER TABLE phase 
CHANGE Name Name VARCHAR(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL  COMMENT Hello world

但它对我来说没有用，因为我无法从我的 php 应用程序生成类似的查询。需要帮助....

原文

I have a table called phase with following fields.
ID,Name.
I want to change its comment using query.

ALTER TABLE phase 
CHANGE Name Name VARCHAR(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL  COMMENT Hello world

But its not useful for me as i wont be able to generate similar query from my php application.
Help needed....

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

厌味 2024-11-23 09:22:17

尝试：

ALTER TABLE `phase` CHANGE `Name` `Name` VARCHAR(200) CHARACTER SET COLLATE latin1_swedish_ci NULL COMMENT 'comment here...'

更新

在您的 PHP 应用程序中尝试以下操作：

$result = mysql_query('DESC `phase`');
if(is_resource($result) && mysql_num_rows($result) > 0){
    while($column =  mysql_fetch_assoc($result)){
        if($column['Field'] === 'Name'){
            $comment_query = "ALTER TABLE `phase` CHANGE `{$column['Field']}` `{$column['Field']}` {$column['Type']} CHARACTER SET COLLATE latin1_swedish_ci {$column['Default']} COMMENT 'comment here...'";
            $result = mysql_query($comment_query);
            echo ($result) ? 'Added comment' : 'Failed to add comment';
            break;
        }
    }
} else{
    echo 'Not a table description result';
}

Try:

ALTER TABLE `phase` CHANGE `Name` `Name` VARCHAR(200) CHARACTER SET COLLATE latin1_swedish_ci NULL COMMENT 'comment here...'

Update

Try this, in your PHP application:

$result = mysql_query('DESC `phase`');
if(is_resource($result) && mysql_num_rows($result) > 0){
    while($column =  mysql_fetch_assoc($result)){
        if($column['Field'] === 'Name'){
            $comment_query = "ALTER TABLE `phase` CHANGE `{$column['Field']}` `{$column['Field']}` {$column['Type']} CHARACTER SET COLLATE latin1_swedish_ci {$column['Default']} COMMENT 'comment here...'";
            $result = mysql_query($comment_query);
            echo ($result) ? 'Added comment' : 'Failed to add comment';
            break;
        }
    }
} else{
    echo 'Not a table description result';
}

回复收藏 0 原文

~没有更多了~