Default value

[cdmafra]

Hello.

 

Is it possible to insert as default value in mysql the username of who is 'logged in' adding a article to the website? Independently of who is the user?

 

Thank you in advance!

[requinix]

Not sure what the difference is between the "username of who is logged in" and the "user", but regardless: not really. You should do that manually in your SQL.

[cdmafra]

  On 9/13/2013 at 6:13 PM, requinix said:

Not sure what the difference is between the "username of who is logged in" and the "user", but regardless: not really. You should do that manually in your SQL.

It's the same thing. There are no ways to set it with a $_user variable or something like that?

[vinny42]

It depends on what you mean by "the user".

 

If you want the DEFAULT setting of a column to use a variable that only exists in PHP then obviously; no you can't do that, you will have to supply the username in your queries.

 

There are systems that use a separate databaseuser for each website user and even they can't use the DEFAULT, but they can use a trigger to fetch the username and fill it in.