Example of how to generate random numbers and concatenate strings in MySQL

Example of how to generate random numbers and concatenate strings in MySQL

This article uses an example to describe how MySQL generates random numbers and concatenates strings. Share with you for your reference, the details are as follows:

Methods used:

concat('a','b','c'); connect string

rand(); Generate random numbers

floor(); take the integer

SQL statement example:

Copy the code 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 are two commonly used SQL online tools for your reference (including SQL statement usage instructions):

SQL online compression/formatting tool:
 http://tools.jb51.net/code/sql_format_compress

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

In addition: I would like to recommend an online random number tool for your reference:

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

Readers who are interested in more MySQL-related content can check out the following topics: "Summary of MySQL Common Functions", "Summary of MySQL Log Operation Skills", "Summary of MySQL Transaction Operation Skills", "Summary of MySQL Stored Procedure Skills" and "Summary of MySQL Database Lock-Related Skills".

I hope this article will be helpful to everyone's MySQL database design.

You may also be interested in:
  • MySQL Query Random Data 4 Methods and Performance Comparison
  • Tips for using MySQL's specified range random number function rand()
  • Code to extract random data from MySQL database table
  • How to get random data in mysql
  • MySQL optimizes the slow method of fetching random data
  • mysql insert a random number into a field (insert a random number into the MySQL database)
  • Detailed explanation of the usage of the concat function in MySQL (connecting strings)
  • Python connects to MySQL and uses fetchall() method to filter special characters
  • sqlserver, mysql connection string steps
  • How to set MySQL connection character set in PHP

<<:  Mini Programs enable product attribute selection or specification selection

>>:  How to manually build a new image with docker

Recommend

Summary of some common methods of JavaScript array

Table of contents 1. How to create an array in Ja...

HTML table markup tutorial (29): cell light border color attribute BORDERCOLORLIGHT

In cells, light border colors can be defined indi...

Analysis of the implementation method of modifying the default network segment of Docker

background All of the company's servers are p...

Two special values ​​in CSS are used to control the inherit and initial methods of the cascade

There are two special values ​​that can be assign...

Is a design that complies with design specifications a good design?

In the past few years of my career, I have writte...

The National Day is coming. Use JS to implement a small tool to generate a National Day style avatar. Detailed explanation of the implementation process

Table of contents 1. Page Layout 2. Image upload ...

MySQL SQL Optimization Tutorial: IN and RANGE Queries

First, let's talk about the in() query. It is...

Example code for implementing a QR code scanning box with CSS

We usually have a scanning box when we open the c...

Solution to the failure of docker windows10 shared directory mounting

cause When executing the docker script, an error ...

Native JS to achieve cool paging effect

This article uses an example to share with you a ...

Vue-Element-Admin integrates its own interface to realize login jump

1. First look at the request configuration file, ...

How to implement the observer pattern in JavaScript

Table of contents Overview Application scenarios ...

Three properties of javascript objects

Table of contents 1. writable: writable 2. enumer...

Example of how to use CSS3 to layout elements around a center point

This article introduces an example of how CSS3 ca...

Summary of commonly used CSS encapsulation methods

1. pc-reset PC style initialization /* normalize....