cascade
on delete cascade,
...
) engine=innodb;
PB
thx in advance.
Rajeev
From: Peter Brawley
To: Rajeev Prasad ; "mysql@lists.mysql.com"
Sent: Wednesday, August 15, 2012 4:01 PM
Subject: Re: suggestion needed for table
thx in advance.
Rajeev
From: Peter Brawley
To: Rajeev Prasad ; "mysql@lists.mysql.com"
Sent: Wednesday, August 15, 2012 4:01 PM
Subject: Re: suggestion needed for table design and relationship
On 2012-08-15 1:54 PM, Rajeev Prasad wrote:
> I
On 2012-08-15 1:54 PM, Rajeev Prasad wrote:
I have to keep this data in MySql, and i am not sure (as SQL/databse is not my
field) how to organise this into one or many tables? right now I would
represent my info as follows:
device_name|HW_version|SW_version|IP_addr_pvt|IP_addr_pub|data_specifi
I have to keep this data in MySql, and i am not sure (as SQL/databse is not my
field) how to organise this into one or many tables? right now I would
represent my info as follows:
device_name|HW_version|SW_version|IP_addr_pvt|IP_addr_pub|data_specific_to_device|associated_service
|associated_