Strings as Primary Keys in MYSQL Database [closed]

by

Technically yes, but if a string makes sense to be the primary key then you should probably use it. This all depends on the size of the table you’re making it for and the length of the string that is going to be the primary key (longer strings == harder to compare). I wouldn’t necessarily use a string for a table that has millions of rows, but the amount of performance slowdown you’ll get by using a string on smaller tables will be minuscule to the headaches that you can have by having an integer that doesn’t mean anything in relation to the data.

More Related Contents:

  1. difference between primary key and unique key
  2. Remove Primary Key in MySQL
  3. Difference between two table structure
  4. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  5. Error Code: 2013. Lost connection to MySQL server during query
  6. MySQL Trigger after update only if row has changed
  7. Strings as Primary Keys in SQL Database [closed]
  8. MySQL Query to select data from last week?
  9. Using an Alias in SQL Calculations
  10. Can a table field contain a hyphen?
  11. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  12. Adding a leading zero to some values in column in MySQL
  13. single fixed table with multiple columns vs flexible abstract tables
  14. Auto Generate Database Diagram MySQL [closed]
  15. View’s SELECT contains a subquery in the FROM clause
  16. Check for x consecutive days – given timestamps in database
  17. MySQL Insert Into from one Database in another
  18. How do I get the ID of multiple inserted rows in MySQL?
  19. How to insert data to MySQL with auto-incremented column(field)?
  20. Case statement in MySQL
  21. Replace Into Query Syntax
  22. Remove special characters from a database field
  23. Proper database model for a user feedback system (an interesting case)
  24. MySQL query, MAX() + GROUP BY
  25. MySQL – how to front pad zip code with “0”?
  26. How to get multiple records against one record based on relation?
  27. MySQL – Replace Character in Columns
  28. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  29. Foreign key constraints: When to use ON UPDATE and ON DELETE
  30. How to use a user variables in MySQL LIKE clause?

Leave a Comment