I am trying to alter column named names type from text to VARCHAR with length L. Where L is the maximum length of the names. I am trying with inner/sub-query as follows: Is this even possible? Any alternative to do…
I am using BIGSERIAL as a Primary key and I want to make use of the deleted row's ids. Example of the table that I want re-use the deleted ids from the deleted rows: DELETE FROM my_table WHERE id=3; INSERT…
Ok, Let's say I have two tables with identical structures but different values : TABLE1 : column.A, column.B, column.C TABLE2 : column.A, column.B, column.C I add columns in table 1, it becomes : TABLE1 : column.A, column.B, column.C, column.D, column.E,…
I just installed Mariadb on my new unix system (Mariadb server version 10.1.37 Debian 9.6). I have the following users: +------------+-----------------------+-------------+-----------+ | user | authentication_string | plugin | host | +------------+-----------------------+-------------+-----------+ | root | | unix_socket | localhost | |…