See below...
> -Original Message-
> From: John Taylor-Johnston [mailto:John.Taylor-
> [EMAIL PROTECTED]
> Sent: Thursday, March 20, 2008 2:17 PM
> To: Sebastian Mendel; mysql@lists.mysql.com
> Subject: Re: relational tables
>
> DROP TABLE IF EXISTS `person`
Sorry, I'm a top quoter. This is what I want to do. I'm still told there
re problems with my keys.
DROP TABLE IF EXISTS `person`;
CREATE TABLE `person` (
`person_id` int(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`email` varchar(255) default NULL,
PRIMARY KEY (`person_id
John Taylor-Johnston schrieb:
I want to make a relational link from `data` to `shopping` so when I
insert a new record in `shopping`, I will see the contents of
`data`.`name` and `data`.`email` as drop-down menus in `shopping`.
This is InnoDB so I should be able to do this by SQL, right?
where
because there isn't any partners table in the FROM
clause!
--- Justin French <[EMAIL PROTECTED]> ha scritto:
> Hi all,
>
> I have three tables:
>
> partners (id,name,url,desc)
> services (id,desc,category)
> partner_service_rel (pid,sid)
>
> Each partner offers a range of services, and each
>
* Javier Gonzalo Gloria Medina
> How I crate this relational tables with mysql.
Using the CREATE TABLE statement:
http://www.mysql.com/doc/C/R/CREATE_TABLE.html >
> where the two tables must be related by id ok
You combine the tables with the SELECT statement, you don't need to do
anything sp
