需要帮助来检索 [英] Need Help in retrieving

问题描述

有人可以帮助我使用mysql yog并且我将我的字段从varchar更改为日期并且它包含日期数据现在它转向0000-00-00如何将其恢复到原始数据上请帮助

Can someone help me with this im using mysql yog and i change my field from varchar to date and it contains date data now it turns to 0000-00-00 how to get it back on its original data pls help

推荐答案

我讨厌这样说，但是...从你上次备份恢复。



当你改变一个数据类型如此彻底，它不会尝试解析它们，它基本上抛弃它并重新开始，因为没有保证从varcharhello到有效日期的转换。



恢复旧版本后，请遵循以下建议： http://stackoverflow.com/questions/7090231/how-to-convert-a-varchar-column-type-to-date-type-without-losing-日期 [ ^ ]



但是如果你没有备份，你就会被填满 - 这是如果可能的话，撤消的复杂变化。

I hate to say this, but...restore from your last backup.

When you change a datatype so radically, it doesn't try to parse them, it basically throws it away and starts again, because there is no guaranteed conversion from a varchar "hello" to a valid date.

When you have restored the old version, follow the advice here: http://stackoverflow.com/questions/7090231/how-to-convert-a-varchar-column-type-to-date-type-without-losing-the-dates[^]

But if you don't have a backup, you are pretty much stuffed - it's a complicated change to undo, if it is even possible.

这篇关于需要帮助来检索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！