• 0

auto stamping mysql username to added entries


Question

Sorry... i'm no mysql guru. (But I'm trying to be!).

Is there a way to add a column to a table that will have an auto value of the username that is currently adding the entry? That is the username used to log into the mysql server.

What about a time stamp?

I'm diving into the MySQL documentation.

If I find it before anyone responds, I'll respond on how I did it.

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

i am not sure but get the login script to set a cookie and when the user adds the entry just put the va,ue of the cookie in aswell

mysql allows you to set a fields to be a timestamp which will input the date in this format 20030103214253

2003 - year

01 - month

03 - day

21 - hour

42- min

53 - sec

Link to comment
Share on other sites

  • 0

I could do that.... but the database will not only have entries coming from web connections but also programs that use a DSN name. And of corse under that DSN name is the mysql ODBC driver which has that computers login/password to the server.

Basically I was hoping to use the mysql login as an entry identifier that was automatically done on the server side. But by the way you sound, it will have to be a seperate deal that is scripted on the client side.

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.