Can I use a function for a default value in MySql?

by

No, you can’t.

However, you could easily create a trigger to do this, such as:

CREATE TRIGGER before_insert_app_users
  BEFORE INSERT ON app_users 
  FOR EACH ROW
  SET new.api_key = uuid();

More Related Contents:

  1. what will be the sql query code of this “Healthcare” database?
  2. Rank function in MySQL
  3. Find nearest latitude/longitude with an SQL query
  4. How to group by week in MySQL?
  5. convert_tz returns null
  6. Convert MySQL to SQlite [closed]
  7. MySQL query String contains
  8. MySQL autoincrement column jumps by 10- why?
  9. Best data type for storing currency values in a MySQL database
  10. ERROR 1067 (42000): Invalid default value for ‘created_at’
  11. MySQL Workbench: How to keep the connection alive
  12. Capitalize first letter. MySQL
  13. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  14. Use a trigger to stop an insert or update
  15. mysql query show multiple tables from one ID column
  16. MySQL: ALTER IGNORE TABLE gives “Integrity constraint violation”
  17. MySQL remote connection fails with “unknown authentication method”
  18. Import MySQL database into a SQL Server
  19. How does MySQL’s ORDER BY RAND() work?
  20. How create json format with group-concat mysql?
  21. What is the difference between SQL and MySQL? [closed]
  22. how to use a like with a join in sql?
  23. Escaping the colon character ‘:’ in JPA queries
  24. How to export / dump a MySql table into a text file including the field names (aka headers or column names)
  25. Laravel MySql DB Connection with SSH
  26. What happens when I exhaust a bigint generated key? How to handle it?
  27. Automatic Rollback if COMMIT TRANSACTION is not reached
  28. Get column sum and use to calculate percent of total (mySQL)
  29. is there a length limit to group_concat or another reason why it would not work on a text field
  30. Sum until certain point – MySql

Leave a Comment