6 Solved Topics

Remove Filter
Member Avatar for
Member Avatar for Tinnin

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 …

Member Avatar for Tinnin
0
336
Member Avatar for cmps

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 …

Member Avatar for pritaeas
0
359
Member Avatar for taekiewzz

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, …

Member Avatar for pritaeas
0
250
Member Avatar for tony75

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) );

Member Avatar for tony75
0
290
Member Avatar for 0xCMD

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 | …

Member Avatar for 0xCMD
0
247
Member Avatar for Pado

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 …

Member Avatar for Pado
0
247

The End.