sql - Accidentally inserted a string into a big int column. Is there any chance of recovering the string? -


While parsing and inserting data, I accidentally created a string (IP address) in a MySQL table in a Biltine column Unused INET_ATON function. Is there any way i can recover the original string?

If you enter an IP address like this:

  test values Enter in ("123.456.888.999");  

then it will be entered as 123456, so you will have the first 2 digits, but the remainder will be lost


Comments