error when dealing with uuid

[vj78]

Where and how is the uuid() function defined? Please show us the code.

Ok, I am 1 step further. There was a trigger that got created by default while creating this uuid or guid field. I deleted that trigger now it is inserting rows using the MySQL sql prompt screen.

The UUID function just inserts UUID() as a string inside of the userguid column. So, it’s not working as planned. I will post a print screen of how I created it.

I am going into the mysql admin panel. I select the database and then the table from left hand navigation. Then click add column.



In here, I am add the name, varchar, length 100, and selecting defined from default column and enter uuid().