开发者

While taking table backup using mysqldump command, can we skip particular column..?

开发者 https://www.devze.com 2023-01-26 11:29 出处:网络
I need to know, is there any option to skip particular column and take remaining table backu开发者_运维技巧p using mysqldump command.

I need to know, is there any option to skip particular column and take remaining table backu开发者_运维技巧p using mysqldump command.

If yes please let me know.


I wanted to move a table from one host to another but only include some of the columns and replace others with dummy data (like password columns). So I made a shell script that makes it possible to run a SELECT query and get INSERT statements as result.

You find the script here: https://gist.github.com/1239299

0

精彩评论

暂无评论...
验证码 换一张
取 消