6 Solved Topics
Remove Filter
|
|
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 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, … |
|
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) ); |
|
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 … |
The End.