unknown error and filling data in MySQL

[Norgy]

CREATE TABLE `norm`.`sphone` (
  `sid` INT NOT NULL,
  `phone` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`sid`, `phone`),
  CONSTRAINT `sid`
    FOREIGN KEY ()
    REFERENCES `norm`.`staff` ()
    ON DELETE RESTRICT
    ON UPDATE RESTRICT);

i am new with MySQL , and when this code is executed, it gives me this error
ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')

REFERENCES `norm`.`staff` ()

ON DELETE RESTRICT

ON UPDATE RESTRICT' at line 6

SQL Statement:

CREATE TABLE `norm`.`sphone` (

`sid` INT NOT NULL,

`phone` VARCHAR(45) NOT NULL,

PRIMARY KEY (`sid`, `phone`),

CONSTRAINT `sid`

FOREIGN KEY ()

REFERENCES `norm`.`staff` ()

ON DELETE RESTRICT

ON UPDATE RESTRICT)

i can not understand the error and don't know how to solve it?
also, would anyone tell me how to fill the tables with data?

[Rabbit]

Your foreign key syntax is wrong. You didn't tell it which fields the foreign key is on.

[Norgy]

could you explain more please :$

[Rabbit]

A foreign key links a field in one table to another field in another table. You didn't specify those fields.

The syntax is:

CREATE TABLE someTable
 (
 field definitions,
 FOREIGN KEY (field in this table) REFERENCES otherTable(field in other table)
 )

[Norgy]

solved, thanks a lot :)
now, i don't know how to fill the tables with data?

[Rabbit]

We limit the threads to one question per. Please create a new thread for your new question.

As a side note, inserting data is one of the basic SQL tasks, you should probably read a tutorial.

[Norgy]

ok, thank you very much :)