How to generate unique id in MySQL?

by

EDIT: This answer has been flagged for being dangerous in the context of destroying a database. Do NOT use this code to generate unique ids in databases!

I use UUID() to create a unique value.

example:

insert into Companies (CompanyID, CompanyName) Values(UUID(), "TestUUID");

More Related Contents:

  1. Query database then email posts from where user is subbed to
  2. Using PHP data in MySQL [closed]
  3. Checking the availability of rooms
  4. Can I parameterize the table name in a prepared statement?
  5. How to properly set up a PDO connection
  6. Getting raw SQL query string from PDO prepared statements
  7. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  8. MySQL Prepared statements with a variable size variable list
  9. Loading .sql files from within PHP
  10. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102 [closed]
  11. Comma separated values in MySQL “IN” clause
  12. MySQL “NOT IN” query 3 tables
  13. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  14. PHP: multiple SQL queries in one mysql_query statement
  15. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  16. Why does this return Resource id #2? [duplicate]
  17. Simple PHP SQL login troubleshooting
  18. Change date format (in DB or output) to dd/mm/yyyy – PHP MySQL
  19. How do you do multiple SQL statements in one mysql_query?
  20. MySql PHP select count of distinct values from comma separated data (tags)
  21. Laravel Eloquent get results grouped by days
  22. MySQL/SQL retrieve first 40 characters of a text field?
  23. How to check if a value already exists to avoid duplicates?
  24. how do I get month from date in mysql
  25. php/mysql zip code proximity search
  26. Updating column so that it contains the row position
  27. MYSQL select a piece of a string and order by that piece
  28. Aggregated query without GROUP BY
  29. PHP/MySQL Pagination
  30. Limit pagination page number

Leave a Comment