foreign-keys

相关标签：javascript jquery android 多少钱 iPhone

How to delete rows with bi-directional dependencies?

I\'m using Oracle 10g Express and trying to delete records from tables with bi-directional 开发者_JAVA百科constraints. I\'m trying to un-thread hundreds of tables and dependencies generated via Hibern[详细]

2023-04-11 13:57 分类：问答
Any drawbacks to starting an ID column of a table with 0?

user_drug.user_id is constrained by Foreign Key drug.id (which is a Primary Key). Table structure is as follows:[详细]

2023-04-11 07:44 分类：问答
MySQL: How to find where a specific primary key is used as a foreign key in other tables?

I\'m working on implementing a function to prevent removal of certain elements in a database (through the front end) if they have other items associated with them in other tables. Otherwise those othe[详细]

2023-04-11 07:43 分类：问答
How to select records from table1 which have table3 options in table2?

Let\'s say, I have three tables: table1: contains various records; table2: contains what records have what options;[详细]

2023-04-11 05:39 分类：问答
Foreign keys on Insert with Struts2 / Hibernate

I\'m new user of Struts 2 w/ hibernate. I have 2 tables : \"Client\" and \"Coordonnees\" (french word)[详细]

2023-04-11 04:23 分类：问答
Should Foreign Keys be used in a structure where multiple options can be selected by a user? If so, how so?

In MySQL, I was advised to store the multiple choice options for \"Drugs\" as a separate table user_drug where each row is one of the options selected by a particular user.I was also advised to create[详细]

2023-04-11 03:26 分类：问答
MySQL drop field; foreign key errorno 150

Problems with MySQL using InnoDB and dropping an unused, foreign key.The foreign key references another table\'s id.However, I don\'t need this field.[详细]

2023-04-10 23:38 分类：问答
optional foreign keys one of which must be mandatory - how?

I have a table that has two optional foreign keys, each to a different table and one of which HAS to be filled in, but it doesn\'t matter which one.I was thinking about using a trigger to enforce this[详细]

2023-04-10 23:09 分类：问答
What's wrong with the Foreign Key Constraint in this table?

MySQL 5.1.59 throws an error with this create table: CREATETABLE IF NOT EXISTS `genre` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,[详细]

2023-04-10 18:48 分类：问答
test if a specific id is used as foreign key in any foreign table entry

i have a table \'users\' with a column \'id\'. this id is used as foreign key in many other tables (like posts, comments, etc.).[详细]

2023-04-10 12:06 分类：问答