t: Monday, October 01, 2001 12:50 PM
> To: [EMAIL PROTECTED]
> Subject: sql syntax INSERT
>
>
>
> Hi,
>
> Im still learning sql so I hope this doesnt sound to basic.
>
> I would like to find out if there is a way to insert a record
> only when (X and Y) do not exist.
>
Robert Martin wrote:
> Hi,
>
> I?m still learning sql so I hope this doesn?t sound to basic.
>
> I would like to find out if there is a way to insert a record only when (X and Y) do
>not exist.
> I have the value to check against stored in a variable.
ALTER TABLE table ADD UNIQUE u_xy_idx ( x,
Hi,
Im still learning sql so I hope this doesnt sound to basic.
I would like to find out if there is a way to insert a record only when (X and Y) do
not exist.
I have the value to check against stored in a variable.
My table looks like the following:
ID | X | Y
-
1 | 10
Hi,
Im still learning sql so I hope this doesnt sound to basic.
I would like to find out if there is a way to insert a record only when (X and Y) do
not exist.
I have the value to check against stored in a variable.
My table looks like the following:
ID | X | Y
-
1 | 10