28 Dec
2017
28 Dec
'17
4:36 p.m.
On Thu, Dec 28, 2017 at 9:34 AM, Sergei Golubchik <serg@mariadb.org> wrote:
In MariaDB (and in SQL standard) the way to achieve that would be to use a nullable column for active, and mark inactive users with NULL. Then you can create a unique index on (phone,active).
That is a neat trick, thanks James and Sergei! -- Jared Beck • (607) 216-5373 • jared@jaredbeck.com