A
A
anton_myaso2015-12-10 22:43:31
MySQL
anton_myaso, 2015-12-10 22:43:31

How to add character to mysql field?

Friends, tell me how to make a request to add a character to the field?
The login field
is needed from the login, conditionally, user to make user1
and so on with the entire database of logins: user1, stepan1, admin1, etc.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
E
Eugene, 2015-12-10
@anton_myaso

update tbl set login=concat(login,'1')

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question