[foreign] Forum Topics

Hello Community, I've been looking around my computers registry and have found a few weird keys under Computer\HKEY_CURRENT_USER\ The keys are:  I'll put them here too in case you want to copy and paste them or something: Computer\HKEY_CURRENT_USER\멘Ṉ싈Ṉ멘Ṉ_ Computer\HKEY_CURRENT_USER\뭘⨱㺀ℎ뭘⨱楎 Computer\HKEY_CURRENT_USER\섀ׂ뤠ׂ߈_ Computer\HKEY_CURRENT_USER\冀⩩览⏡冀⩩_ Computer\HKEY_CURRENT_USER\鬰竣鯐竣鯰竣骐竣鳐竣饰竣鰰竣騰竣馐竣 Computer\HKEY_CURRENT_USER\㦸ᷢ흠຾㦸ᷢE Could anyone tell me what …

Hi All, I'm not sure if this is a technical issue, preference or a question about best form. I have a 'users' table and a 'contacts' table. 'users' and 'contacts' have no direct relation. Both contain an email address for each record in their own table. I want to send …

Hello, I have two tables one for 'users' and another for 'vendor_service' in database named 'star'. In vendor_service table i've stored users id as a foreign key. Now if i try to insert values in vendor_service table it shows following error. Cannot add or update a child row: a foreign …

Cannot add or update a child row: a foreign key constraint fails .this error occured then what can i do.

has google discontinued this option? if not, then where it is? i remember, last time i checked, it was in "search tools option" right above the "verbatim" option. now its not there. HELP

Hello, I want to create tables in database (using SQL) and add foreign keys to each table refering to the other one. For example: CREATE TABLE ONE( ID INT NOT NULL, NAME VARCHAR(20) NOT NULL, TWOID INT NOT NULL, PRIMARY KEY (ID), FOREIGN KEY (TWOID) REFERENCES TWO (ID) ON DELETE …

I have a table called `DUTY` (columns: `dutyid, dutyname, staffid`) and a table called `STAFF` (columns: `staffid, staffname`) In order to be fair, each of the staff will be auto assigned to each duty entry (record). So what should I do whenever I would like to insert a duty entry, …

I'm learning PHP and MySQL, and I'm trying to create a simple online pastebin website. I want to create both anonymous and logged in user pastes. I created a 'user' table with uid, name and password columns, and a 'pastes' table with pid, paste and uid columns. In a viewpaste.php …

I'm using the statement insert into Oscar.MenuItem (idMenuItem, name, description, price, idCategory, code, sortIndex) select * from menItem; The result is: Error: Cannot 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 ACTION ON UPDATE NO …

How can I insert two row to supplier table? CREATE TABLE supplier ( supplier_nr NUMBER(10), supplier_id VARCHAR2(20) NOT NULL, price NUMBER(10) NOT NULL, CONSTRAINT supplier_supplier_nr_pk PRIMARY KEY(supplier_nr), CONSTRAINT supplier_supplier_id_fk FOREIGEN KEY(supplier_id) REFERENCES varugrupp(supplier_id) );

HI GUYS .. im trying to make foreign key relation between whishlist_tbl(foreign) table and account_tbl(primary key) table both are integer data container ## scenario ## i have user deatail table that is account_tbl and whish list table i.e wishlist_tbl i want that when user make a wish book then he …

Hello people, I want to create 'Voyageur' table that references a successfully created table which name is 'Categorie',. But I get this error message when I click on 'run': [COLOR="Red"]ORA-02438: Column check constraint cannot reference other columns [/COLOR] Here is my 'Voyageur' Table that makes me a problem around its …

Hii All, i'm newbie in this forum and in php i got a problems, i was developing simple website i had 3 tables in there table request, table upload, and table feedback which in id_request is foreign key in table upload and table feedback 1. how to update the id_request …

hii all, i've create upload website, i've been stuck with following error i had 3 tables in my database table request, table upload and table feedback table request : id_request;---primary key subjek; isi; pelaksana; table upload : id_upload,----primary key id_request,----foreign key filename, filedata, filesize, filetype table feedback : id_feedback,----primary key …

I have a person table which specifies common attributes of sub tables teacher, student and staff. A person can be either teacher, student or both. I use the same primary key in sub tables which access the person table as foreign key (teacher_id, student_id is the same as of person_id). …

Hi all. I have a database table containing the details of, lets say, Ninjas. It has a primary key called NinjaID. I have a second table containing a match-up of which Ninjas will be fighting eachother. This table has 4 Columns: 1.) MatchID 2.) BlueCornerNinjaID 3.) RedCornerNinjaID 4.) DateTime What …

Hi, I am trying to create a foreign key between 2 tables. I am using MySQL Workbench but every time I create the foreign key relationship, it just dissappears after clicking "apply"... Initially I thought it was Workbench so I tried the legacy Query Browser - but it does the …

Greetings, I have table CUSTOMER: [CODE] mysql> describe CUSTOMER; +---------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------+-------+ | CUSTOMER_NUM | char(3) | NO | PRI | NULL | | | CUSTOMER_NAME | char(35) | NO | | NULL | | | STREET | …

Every once in a while I run into this problem and finally decided to consult the experts. :) I insert foreign characters (Czech letters) into my MySQL database and see them there. They look fine. But when I try to retrieve them using PHP they come out with question marks …