0 votes
1 view
in SQL by (22.4k points)

There are two columns in a MySQL table: SUBJECT and YEAR.

I want to generate an alphanumeric unique number which holds the concatenated data from SUBJECT and YEAR.

How can I do this? Is it possible to use a simple operator like +?

Please log in or register to answer this question.

Related questions

0 votes
1 answer
asked Jul 29, 2019 in SQL by Tech4ever (22.4k points)
0 votes
1 answer
asked Jul 18, 2019 in SQL by Tech4ever (22.4k points)
0 votes
1 answer
asked Jul 5, 2019 in SQL by Tech4ever (22.4k points)
0 votes
1 answer
asked Jul 30, 2019 in SQL by Tech4ever (22.4k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...