AndrewJames schrieb:
> Hey,
>
> i have a table called users which has my users in it, each have a uid
> field.
> I also have a stories table which has stories in it each with a sid field
> for each story but also a uid field so i know which user the story
> belongs
> to.
>
> i want to write a que
AndrewJames schrieb:
> Hey,
>
> i have a table called users which has my users in it, each have a uid
> field.
> I also have a stories table which has stories in it each with a sid field
> for each story but also a uid field so i know which user the story
> belongs
> to.
>
> i want to write a quer
AndrewJames schrieb:
> Hey,
>
> i have a table called users which has my users in it, each have a uid
> field.
> I also have a stories table which has stories in it each with a sid field
> for each story but also a uid field so i know which user the story
> belongs
> to.
>
> i want to write a quer
Hey,
i have a table called users which has my users in it, each have a uid field.
I also have a stories table which has stories in it each with a sid field
for each story but also a uid field so i know which user the story belongs
to.
i want to write a query that will display the story depending
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
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?
Thanks,
John
DROP TABLE IF EXISTS `
* Dee
> I have a table that contains ids for several other tables. Setup is as
> followed:
>
> +--+--+--+-+-+
> +
> | Field| Type | Null | Key | Default | Extra
> |
> +--+--+--+-
Hi,
I have a table that contains ids for several other tables. Setup is as
followed:
+--+--+--+-+-++
| Field| Type | Null | Key | Default | Extra |
+--+--+--+-+-+-
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
>
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 services has an id,
description, and category.
Now, it's EASY to search for partners that offer a certain service, but I
can't fig
* 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
Hi people :
How I crate this relational tables with mysql.
Table users
| id | user name| e-mail | password | carrier| semester |
table assignments
| id | assignments |
where the two tables must be related by id ok
thanks for the help
14 matches
Mail list logo
