+ 1
Please any suggestions of how I can insert information in a table(sql).
The table client contains (Id,name,age) The table command contains(id,product,price,name) So name it is a foreign key in the command table So how I can insert values in the command table It give me an error because it says that name it is inside the client command.
2 Answers
+ 1
Hi,
If name in command table it is the reference to client table, so before inserting a record to command table you should insert a value to client table. Then use this value while inserting records to command table.
Hope it help you!)
+ 1
Actually name is in client table
Wich is a foreign key in Command table