Method example for MySQL to generate a random number and connect the string, mysql Random Number

Method example for MySQL to generate a random number and connect the string, mysql Random Number

This article describes how MySQL generates random numbers and connects strings. We will share this with you for your reference. The details are as follows:

Method used:

Concat ('A', 'B', 'C ');Connection string

Rand ();Generate random number

Floor ();Returns an integer.

SQL statement example:
Copy codeThe Code is as follows: UPDATE user set reg_ip = concat (floor (RAND () * 250 ),'. ', floor (RAND () * 250 ),'. ', floor (RAND () * 250 ),'. ', floor (RAND () * 250) where username = 'xxx'

PS: here we recommend two commonly used online SQL tools for your reference (including SQL statement usage instructions ):

SQL online compression/formatting tools:
Http://tools.jb51.net/code/ SQL _format_compress

SQL code online formatting and beautification tools:
Http://tools.jb51.net/code/sqlcodeformat

In addition, we recommend an online random number tool for your reference:

Online random number/string generation tool:
Http://tools.jb51.net/aideddesign/suijishu