Convert int to varchar

desmondtanck · #1 (**permalink**) 05-18-07, 05:08

I'm trying to do a looping to create large amout of user.

DECLARE v1 INT DEFAULT 0;
WHILE v1 < 10000 DO
INSERT INTO account
VALUES ("user"+v1,"password","abc@email.com");
SET v1 = v1 + 1;
END WHILE;

I tried to use: "user"+v1

but it doesnt seem to be working

any idea how to solve it?

thanks a lot

aschk · #2 (**permalink**) 05-18-07, 05:24

You need to use the format

Code:

CONCAT('user',CAST(1 AS BINARY))

so :

Code:

DECLARE v1 INT DEFAULT 0;
WHILE v1 < 10000 DO
INSERT INTO account
VALUES (CONCAT('user',CAST(v1 AS BINARY)),'password','abc@email.com');
SET v1 = v1 + 1;
END WHILE;

p.s. please use single quotes ' to encapsulate strings, NOT double quotes "

aschk · #3 (**permalink**) 05-18-07, 05:28

Just decided to do a spot of manual reading on the subject and in MySQL the CONCAT function implicitly converts numbers to BINARY type.

So :
CONCAT('user',CAST(1 AS BINARY)) === CONCAT('user',1)

Internet Services

Web Development

Digital Marketing

Consumer Tech