mysql combine string + int value

Question

I have this table in mysql.

CREATE TABLE `numbering` (
    `numbering_id` INT(11) NOT NULL AUTO_INCREMENT,
    `document_type` VARCHAR(255) NOT NULL,
    `current_no` int(15) NOT NULL DEFAULT '0',
    `next_no` int(15) NOT NULL DEFAULT '1',
    `pattern_name` VARCHAR(255) NULL,
    `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`numbering_id`)
);

I add in a record.

insert into numbering (document_type, current_no, next_no, pattern_name) values ('CUST_INV_NUM', 0, 1, 'INV');`

and i try to retrieve a value by doing:

select (pattern_name + '-' + next_no)
from numbering
where document_type = 'CUST_INV_NUM';`

I get value 1 returned. I am expecting INV-1 how do i do it?

Shadow · Accepted Answer · 2020-07-05 07:39:38Z

2

i figured out the answer..

select CONCAT(pattern_name, '-' , next_no) from numbering where document_type = 'CUST_INV_NUM';

edited Jul 5, 2020 at 7:39

Shadow

34.5k10 gold badges67 silver badges76 bronze badges

answered Jul 10, 2018 at 9:43

Jacel

3475 gold badges11 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gordon Linoff · Accepted Answer · 2018-07-10 10:50:49Z

1

Try using Concat (more info here)

select concat(pattern_name, '-', next_no)
from numbering
where document_type = 'CUST_INV_NUM';

edited Jul 10, 2018 at 10:50

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

answered Jul 10, 2018 at 9:44

user2590928

17610 bronze badges

Comments

Namratha · Accepted Answer · 2018-07-10 13:46:41Z

0

You can also try the below:

    select (pattern_name + '-' + str(next_no))
    from numbering
    where document_type = 'CUST_INV_NUM';

This query returns a string, with output as:'INV-1'

answered Jul 10, 2018 at 13:46

Namratha

322 bronze badges

Collectives™ on Stack Overflow

mysql combine string + int value

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related