Shulou(Shulou.com)06/01 Report--

This article is about the methods of converting strings to int types in mysql. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

Methods for converting strings to int types in mysql: you can use the Convert () method to do the conversion, for example, [SELECT CONVERT ("2017-08-29", DATE);].

You can use the Convert (field name, type) method to do the conversion.

Syntax format:

SELECT CONVERT (filedName, UNSIGNED INTEGER)

For example:

SELECT CONVERT (2017-08-29, DATE)

Commonly used conversion types

Thank you for reading! This is the end of the method of converting strings to int types in mysql. I hope the above content can be helpful to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.