Search DaniWeb - foreign-key

Re: ‘Advanced AI should be treated similar to Weapons of Mass Destruction’ 2 Days Ago by Reverend Jim Based on the proliferation of AI generated content, and the age-old rule of garbage in, garbage out, what will be the result of AI models being trained on ever increasing amounts of content generated by other AI platforms? Will we get into a negative feedback loop where the output will become so polluted with bad input that it will be effectively … Re: ‘Advanced AI should be treated similar to Weapons of Mass Destruction’ 2 Days Ago by jwenting Even worse: the junk being deliberately fed to AIs is already at the stage where the results are useless BUT those results are blindly believed by many people BECAUSE they're generated by AI and therefore supposedly automatically correct! Think Google's disastrous launch of their image generator which would under no condition generate Caucasian … ‘Advanced AI should be treated similar to Weapons of Mass Destruction’ 1 Week Ago by Johannes C. …Fellow of the Hellenic Institute of International & Foreign Law and a Senior Adviser at the Cambridge …Policy Lead](https://archive.is/m0nbQ) at the British Foreign Office. Regarding Artificial Intelligence, my fascination long predates ChatGPT…their human handlers. ## #8) What are the key areas or applications of AI that pose the greatest … Re: Foreign key 9 Years Ago by Schol-R-LEA … it happens, there is a way to add a foreign key to a table in Netbeans, but it isn't … the field) you are going to use as a foreign key in the table you are relating, making sure it is…` which I will set a foreign key constraint on: ALTER TABLE APP.Address ADD CONSTRAINT address_state_fk FOREIGN KEY (state) REFERENCES State (id)… FOREIGN KEY 11 Years Ago by Chesico … add or update a child row: a foreign key constraint fails (`Oscar`.`MenuItem`, CONSTRAINT `fk_MenuItem_Category1` FOREIGN KEY (`idCategory`) REFERENCES `Category` (`idCategory`) ON DELETE NO… Foreign key 11 Years Ago by shakayu …Friends, Am actually trying to get a Foreign key which is a Primary key in Diagnosis table Controller: <?php… $options = array( 0 => 'Please Select' ); foreach ($AppTreatments as $key => $value) { $options[$value->Diagnosis_ID] = $value->Diagnosis_Name; … Re: Foreign key 9 Years Ago by Clif40RD basically im asking if theres another way in which I can create foreign key despite the fact that I cant make the relations by simply having the characters of a primary in another table or by setting those certain characters to be that of a foreign key Re: Foreign key 9 Years Ago by Schol-R-LEA … we're on the same page: you went to the 'Foreign Keys' section for the 'Animal_Cruelty' table, selected 'Execute Command', and… something like it): ALTER TABLE APP.Animal_Cruelty ADD CONSTRAINT animal_cruelty_branch_fk FOREIGN KEY branch_codes REFERENCES Branch_and_Branch_Code (branch_codes) and executed it? Re: Foreign key 9 Years Ago by Schol-R-LEA … it, like so: ALTER TABLE APP.Branch_and_Branch_Code ADD CONSTRAINT animal_cruelty_branch_fk FOREIGN KEY branch_codes REFERENCES Animal_Cruelty (branch_codes) It would be an easy mistake… first learning SQL, in fact. If you look under the Foreign Keys section for `Branch_and_Branch_Code`, does anything show up? Foreign key 9 Years Ago by Clif40RD Hey there!!!!!.......I'm kind of having a problem with creating a foreign key in the derby database on the netbeans platforms.Can anyone help me please? Re: Foreign key 9 Years Ago by Clif40RD ohkay what exactly im trying to say is that the derby database base in the netbeans platform doesnt support foreign key creation natively.....honestly I cant be more specific than that Re: Foreign key 9 Years Ago by Schol-R-LEA This is where you will find the information about the foreign key constraint after it is created. Re: Foreign key 9 Years Ago by Clif40RD Nothing is showing up in any of the foreign key folders. Foreign Key Error: Cannot Add or Update a Child Row 11 Years Ago by atikah8890 …, `created` date NOT NULL, PRIMARY KEY (`set_id`), UNIQUE KEY `r_id` (`r_id`,`q_id`), KEY `q_id` (`q_id`) ADD CONSTRAINT `eval_set_ibfk_1` FOREIGN KEY (`r_id`) REFERENCES `result` (`r_id`), ADD… Foreign key referential integrity keeping me from inserting records. Help! 11 Years Ago by istrika …(1) DEFAULT NULL, PRIMARY KEY (`orderno`), KEY `code` (`code`), KEY `fk_id` (`fk_id`), CONSTRAINT `orderinfo_ibfk_3` FOREIGN KEY (`fk_id`) REFERENCES `customers` (`id`), CONSTRAINT `orderinfo_ibfk_2` FOREIGN KEY (`code`) REFERENCES `status… Re: Foreign key constraint fails 15 Years Ago by wilch … table `categories` -- ALTER TABLE `categories` ADD CONSTRAINT `fk_categories_categories` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`) ON DELETE NO ACTION ON…add or update a child row: a foreign key constraint fails (`myapp`.`categories`, CONSTRAINT `fk_categories_categories` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`) … Foreign key problems 13 Years Ago by Antrim … the table 'order', I put two foreign keys: FK_id_admin (which relates to the … a child row: a foreign key constraint fails (`trigo_musical`.`order`, CONSTRAINT `FK_id_admin` FOREIGN KEY (`id`) REFERENCES `admin`… a child row: a foreign key constraint fails (`trigo_musical`.`order`, CONSTRAINT `FK_id_customer` FOREIGN KEY (`id`) REFERENCES `customer`… Foreign Key is different than primary key 15 Years Ago by SOB224 … value with the first table's primary key. currently foreign key has all zero values in all of … varchar(15) NOT NULL, Course_id int NOT NULL, FOREIGN KEY (Course_id) REFERENCES CourseList(Course_id) ON DELETE CASCADE )';[/code…] how should i write foreign key code to link "StudentAccess's Course_id"… Foreign Key Constraints not applied? 13 Years Ago by 0xCMD … I attempted to add an integrity constraint (A Foreign Key) to the CUSTOMER_NUM column in the ORDERS table as… [CODE] mysql> alter table ORDERS -> add foreign key (CUSTOMER_NUM) references CUSTOMER; Query OK, 7 rows affected (0…intentionally try to violate the integrity constraint of the foreign key as follows (by adding a row that contains… Foreign key constraint fails 15 Years Ago by brunope … table `categories` -- ALTER TABLE `categories` ADD CONSTRAINT `fk_categories_categories` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`) ON DELETE NO ACTION ON…add or update a child row: a foreign key constraint fails (`myapp`.`categories`, CONSTRAINT `fk_categories_categories` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`) … Re: Foreign key referential integrity keeping me from inserting records. Help! 11 Years Ago by istrika So I tried playing around with the foreign keys some. I dropped the keys then re-added them … add or update a child row: a foreign key constraint fails (`testing`.`orderinfo`, CONSTRAINT `orderinfo_ibfk_3` FOREIGN KEY (`fk_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE… Foreign key constraint 10 Years Ago by [NOPE]FOREVER …NULL CONSTRAINT PART_ITEM_UI1 UNIQUE(PART_ID)-- set unique FOREIGN KEY REFERENCES dbo.PARTS(PART_ID), --reference PARTS … QUANTITY INT NOT NULL, FOREIGN KEY(TICKET_NUMBER, TICKET_LINE_NUMBER) REFERENCES dbo.TICKET_LINES(TICKET_NUMBER, TICKET_LINE_NUMBER), FOREIGN KEY (TICKET_NUMBER) REFERENCES dbo.TICKET_LINES… Foreign key to access multiple tables 12 Years Ago by chandimak … sub tables which access the person table as foreign key (teacher_id, student_id is the same as of person_id). [ Refer the… teacher and student, using it as a primary key as well as foreign keys to both tables teacher and student. But…I found (I thought to do this using person_id as foreign key as both teacher_id and student_id is the same as the… Re: Foreign Key is different than primary key 15 Years Ago by DiGSGRL I notice on the Foreign key explanation from the MySQL manual that their tables are INNODB. [URL="http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html"]http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html[/URL] Re: Foreign key constraint fails 15 Years Ago by brunope …, I had to delete the foreign key: [code] ALTER TABLE `categories` DROP FOREIGN KEY `fk_categories_categories`; [/code] and after the index key: [code] ALTER TABLE `categories… add datas but I'm wondering if I should use foreign key constraint, is it worth it? Re: Foreign Key Constraints not applied? 13 Years Ago by 0xCMD …and then try: [CODE=sql]ALTER TABLE `ORDERS` ADD FOREIGN KEY(`CUSTOMER_NUM`) REFERENCES `CUSTOMER`(`CUSTOMER_NUM`);[/CODE][/QUOTE] I thought Innodb… to this, it says it is enabled, but still the foreign key constraint is not enforced. [CODE] mysql> show engines; … Foreign key error when inserting data in SQL 9 Years Ago by Violet_82 …SQL_error.jpg): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_expenses_ToexpenseCode". The conflict occurred … insert data in the table with the foreign key...and that's exactly my situation, in…s11.postimg.org/6wdkcdlzn/expense_Code.jpg and expenses (foreign key): http://s12.postimg.org/b0mamknd9/expenses.jpg … Re: Foreign key constraint fails 15 Years Ago by brunope … wilch, thank you for replying. I didn't use the foreign key volountary. It was the way MySQL Workbench create the table…: [code]#1217 - Cannot delete or update a parent row: a foreign key constraint fails[/code] Why do I have this error? How… foreign key problem 15 Years Ago by bozkurt …), ID2 VARCHAR(10) ) [/code] I want to add foreign key to table2 which ID1 and ID2 is different but referenced… Msg 1785, Level 16, State 0, Line 2 Introducing FOREIGN KEY constraint 'blabla' on table 'blabla' may cause cycles or…NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. Msg 1750, Level 16, State 0, Line … Re: Foreign key problems 13 Years Ago by smantscheff … your design you have to allow NULL values in the foreign key fields so that an order can be related either to…