primary-key
Is it insecure to reveal a row's primary key to the user?
Why do many applications replace the primary key of a database with a seemingly random alternative id when revealing the record to the user?[详细]
2023-03-25 03:55 分类:问答Can I avoid redundant primary key columns in a MySQL table for django (python)?
I am aware of the fact, the if I use the ORM of Django every table has to have a primary key column. Somehow if you have a many_to_many table which links to tables (let\'s call them authors and books)[详细]
2023-03-24 18:50 分类:问答postgresql: error duplicate key value violates unique constraint
This question have been asked by several people but my problem seems to be different. Actually I have 开发者_开发问答to merge same structured tables from different databases in postgresql into a new D[详细]
2023-03-24 00:35 分类:问答Adding Item with Many-to-Many Relationship In Entity Framework
I am getting a primary key violation error when I attempt to add an item with a many-to-many relationship:[详细]
2023-03-22 17:10 分类:问答Primary key value after insertion of row in SQL Server 2005
In SQL Server 2005 I am inserting a row into a table usinga stored procedure and I want to fetch the new primary开发者_高级运维 key value justafter inserting that row. I am using following approach to[详细]
2023-03-22 04:58 分类:问答What primary key to use in my SQLite database?
I have a .csv file that I turned into an SQLite database with the first column as a date and time (as a TEXT datatype because it\'s in the format 7/20/201112:00:00 PM), the second column as the subsec[详细]
2023-03-22 04:54 分类:问答Two primary keys specified in MySQL database
I am trying to create a test database that is a replica of a preexisting database. I am using Django models (theoretically the models used with the original database) in order to do this. I recently i[详细]
2023-03-22 00:47 分类:问答How to best explain on what fields should a user join on?
I need to explain to somebody how they can determi开发者_开发百科ne what fields from multiple tables/views they should join on.Any suggestions?I know how to do it but am having difficulty trying to ex[详细]
2023-03-18 17:26 分类:问答Which is faster to find repetitions?
I have a table with 1 column and I want to check repetition of a value between 10,000 available rows.[详细]
2023-03-17 22:07 分类:问答Primary and foreign keys
Simple question, can\'t seem t开发者_如何学编程o find an answer on Google. I\'m normalizing a database and I\'m converting one of the tables to 2nd Normal Form. Question is: can the primary key of a t[详细]
2023-03-17 04:41 分类:问答