3 How do I show columns in a mysql table?.ROOT: PURCHASE_ERRORS CHILD: yellow key ERRORS(CCPY0208) & yellow key PURCHASE(CCPY0108) ROOT: PURCHASE CHILD: yellow key CONTROL(CCPY0104) & red key PURCHASE_ERRORS(CCPY0108) ROOT: ERRORS CHILD: red key PURCHASE_ERRORS(CCPY0208) Does this mean anything to you Ken ? Im working with a test database not exactly sure how reliable and accurate. A red key indicates that a foreign key is defined by the child node table and references the primary key of the parent node (parent:child = 1:n). A symbol with a yellow key indicates that a foreign key is defined by the parent node, referencing the primary key of the child node (parent:child = n:1). Subsidiary table entries are displayed with their table name followed by the foreign key name joining the table with the parent node. The children of a node are those tables joined to the parent node by foreign key relations. The root node represents the initially selected table. A dialogue box showing foreign key relations with tables. When I do an Extended quick browse of SQL Developer. The errors I keep getting for different use cases are: The insert value of the FOREIGN KEY "CCPY0208" is not equal to any value of the parent key of the parent table(All 4) The insert value of the FOREIGN KEY "CCPY0108" is not equal to any value of the parent key of the parent table(W/O SEND-ID) The insert value of the FOREIGN KEY "CCPY0108" is not equal to any value of the parent key of the parent table(W/O CONTROL-ID) The insert value of the FOREIGN KEY "CCPY0108" is not equal to any value of the parent key of the parent table(W/O ORDER-ID) The insert value of the FOREIGN KEY "CCPY0208" is not equal to any value of the parent key of the parent table(W/O ERROR_NO) The insert value of the FOREIGN KEY "CCPY0108" is not equal to any value of the parent key of the parent table(ONLY ERROR_N0) The insert value of the FOREIGN KEY "CCPY0108" is not equal to any value of the parent key of the parent table(ONLY SEND-ID) The insert value of the FOREIGN KEY "CCPY0108" is not equal to any value of the parent key of the parent table(ONLY CONTROL-ID) Atleast I am unable to see it displayed in either. Thats the thing KenJ, I dont have a CCPY0208 value for either a,b,c or d. **PURCHASE_ERRORS** **foreign key column || foreign key table || foreign key table column** ERROR-NO || ERRORS || ERROR-NO ERROR-NO || ERRORS || ERROR-NO CONTROL-ID || PURCHASE || CONTROL-ID CONTROL-ID || PURCHASE || CONTROL-ID SEND-ID || PURCHASE || SEND-ID SEND-ID || PURCHASE || SEND-ID ORDER-ID || PURCHASE || ORDER-ID ORDER-ID || PURCHASE || ORDER-ID ***How Do I get the INSERT statement to work ?*** ![]() **TABLE RELATIONSHIPS** as seen in RazorSQL tool **PURCHASE** **foreign key column || foreign key table || foreign key table column** CONTROL-ID || CONTROL || CONTROL-ID CONTROL-ID || CONTROL || CONTROL-ID SEND-ID || CONTROL || SEND-ID SEND-ID || CONTROL || SEND-ID **NOTE:** **CONTROL** is another table belonging to the same database. The same goes for 'd' in **ERRORS** and **PURCHASE_ERRORS** in *ERROR-NO* column. The values 'a', 'b' and 'c' already exist in both **PURCHASE** and **PURCHASE_ERRORS** in their respective *SEND-ID, CONTROL-ID and ORDER-ID* columns. ![]() ***Question:*** I am trying to **INSERT** into PURCHASE_ERRORS (SEND-ID, CONTROL-ID, ORDER-ID, ERROR-NO) VALUES (a,b,c,d) **NOTE:** 'a','b' and 'c' are variables derived from **PURCHASE** table and 'd' from **ERRORS** table I receive an error that looks like - *The insert value of the FOREIGN KEY "CCPY0208"' is not equal to any value of the parent key of the parent table*. **PURCHASE** table consists of 50 columns with the PRIMARY KEYS being *SEND-ID*, *CONTROL-ID* and *ORDER-ID* **PURCHASE_ERRORS** table consists of 4 columns all of which PRIMARY KEYS namely *SEND-ID*, *CONTROL-ID*, *ORDER-ID* and *ERROR-NO* **ERRORS** table consists of 2 columns both PRIMARY KEYS named *ERROR-NO* and *ERROR-DESCRIPTION*. I have with me 3 tables **PURCHASE**, **PURCHASE_ERRORS** and **ERRORS**.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |