Default record if no other - mysql

Question

Default record if no other - mysql

Asked 8 years, 10 months ago

Viewed 100 times

2

Is it possible to program the database to have a default record if there is no other record in the table? making the table impossible to be empty.

then if there are other records it ignores the default if it has none it uses the default.

it is possible?

I am implementing access permissions on a system that already has many users and most users do not have registered permission so it causes problems when checking permissions and so on.. then I would like to mount a record that always existed by default configuration.

It would probably be the case to do this in the application. IF has record in db, $permissions = db field, Else $permissions = default user. The advantage of this is that if there are several different permissions, you only write different permissions to each user.

– Bacco

2016/02/26 at 14:09
Yes. the biggest problem is that these permissions are tied to different plans so I must have basic plans and permissions registered @Bacco

– Silvio Andorinha

2016/02/26 at 14:12
@Silvioandorinha I think that the best option is to try to correct the method that validates the permissions, I think a lot of ways to create a default record in the bank.

– Pablo Tondolo de Vargas

2016/02/26 at 14:19

2 answers

Browser other questions tagged mysql laravel-5 phpmyadmin migrations

You are not signed in. Login or sign up in order to post.

by Daniel Saraiva • **549** points · Answer 1 · 2016-02-26T14:09:59+00:00

-1

You can create a Rigger that when adding a user, you check if that user has any record in the table of PERMISAO, if it does not have it inserts a default perm, if it has it ignores.

Yes.. the problem is not with new users, but with existing users.. for new users I have already done this type of treatment

– Silvio Andorinha

2016/02/26 at 14:11
1

For existing users you will need to make a treatment script. You can make a query by doing JOIN select USUARIO.USU_CODIGO, USU_NOME, GRU_CODIGO from USUARIO
left join USUGRUPO
ON USUARIO.USU_CODIGO = USUGRUPO.USU_CODIGO
WHERE GRU_CODIGO IS NULL The search result above will bring me all users who are not in the table USUGRUPO, being thus caught these users and I do an Insert with the default value

– Daniel Saraiva

2016/02/26 at 14:18
I adapted this interim solution from left join.

– Silvio Andorinha

2016/02/26 at 14:21

by Maicon Herverton • **877** points · Answer 2 · 2016-02-26T14:11:35+00:00

You can create a fictitious id and do the following:

SELECT (SELECT id FROM tbl WHERE id = 9823474) AS id;

Works with Postgresql, SQL Server andMysql. Also with Sqlite.

Alternative with UNION ALL:

SELECT id FROM tbl WHERE id = 9823474
UNION  ALL
SELECT NULL -- FROM DUAL  -- apenas para Oracle
LIMIT 1;

Source: https://stackoverflow.com/questions/8098795/return-a-value-if-no-record-is-found