If Exists?

stscrc · #1 (**permalink**) 02-13-06, 19:56

What (if any) is the equivalent of SQL Servers IF EXISTS command in MySQL?

SQL Server example:
IF EXISTS (SELECT * FROM MYTABLE WHERE COLUMN=2)
(
INSERT INTO OTHERTABLE (COL) VALUES ('c')
)

Pat Phelan · #2 (**permalink**) 02-14-06, 03:36

I don't know of any equivalent, but that doesn't mean that none exists.

-PatP

Morthane · #3 (**permalink**) 02-14-06, 17:28

I just found an example myself! This example does an insert if a condition is met. Replace everything in brackets [] with known values.

Code:

IF EXISTS (select [col] from [table] where [col] = [value]) THEN
insert into [table] ([col]) values ([value]);
END IF;

Internet Services

Web Development

Digital Marketing

Consumer Tech