Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed 7 years ago. Improve this question Here we go again, the old argument still arises… Would we better have a business key … Read more
Is there a measurable performance difference between using INT vs. VARCHAR as a primary key in MySQL? I’d like to use VARCHAR as the primary key for reference lists (think US States, Country Codes) and a coworker won’t budge on the INT AUTO_INCREMENT as a primary key for all tables. My argument, as detailed here, … Read more
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 1 year ago. Improve this question I am not very familiar with databases and the theories behind how they work. Is it any slower from a … Read more
I have the following table schema which maps user_customers to permissions on a live MySQL database: mysql> describe user_customer_permission; +——————+———+——+—–+———+—————-+ | Field | Type | Null | Key | Default | Extra | +——————+———+——+—–+———+—————-+ | id | int(11) | NO | PRI | NULL | auto_increment | | user_customer_id | int(11) | NO | PRI … Read more
Here is a gross oversimplification of an intense setup I am working with. table_1 and table_2 both have auto-increment surrogate primary keys as the ID. info is a table that contains information about both table_1 and table_2. table_1 (id, field) table_2 (id, field, field) info ( ???, field) I am trying to decided if I … Read more
I have a table called provider. I have three columns called person, place, thing. There can be duplicate persons, duplicate places, and duplicate things, but there can never be a dupicate person-place-thing combination. How would I ALTER TABLE to add a composite primary key for this table in MySQL with the these three columns? 6 … Read more
I have an existing table called Persion. In this table I have 5 columns: persionId Pname PMid Pdescription Pamt When I created this table, I set PersionId and Pname as the primary key. I now want to include one more column in the primary key – PMID. How can I write an ALTER statement to … Read more
When writing django queries one can use both id/pk as query parameters. Object.objects.get(id=1) Object.objects.get(pk=1) I know that pk stands for Primary Key and is just a shortcut, according to django’s documentation. However it is not clear when one should be using id or pk. 2 Answers 2
I have a table with existing data. Is there a way to add a primary key without deleting and re-creating the table? 5 Answers 5
When should I use KEY, PRIMARY KEY, UNIQUE KEY and INDEX? 8 Answers 8
