Re: mysql sql question

[Peter Brawley]

Bruce,

>i have two hypothetical tables
>create table owner (
>    -> name char(20) ,
>    -> ownerid int(10) auto_increment primary key);

>create table dog (
>    -> name char(20) ,
>    -> ownerid int(10),
>    -> dogid int(10) auto_increment primary key);

>i'm curious as to how i'd go about inserting a name and the id of the
owner,
>in table "dog", in a single sql statement.

>something like this psuedo sql..
> insert table (name, ownerid) values ($name, $ownerid)
>   where owner.owner = owner

INSERT INTO takes a single table arg, so to insert int o2 tables,you need
editable Views (not yet in MySQL) or at least Stored Procedures (MySQL
version 5) on the server side, or you can, as you suggest, do it in the app.

PB