fuuuuuuu-mysql.sql

Fuuuuuu-

-- This is T-SQL (SQL Server). This demonstrates two things MySQL can't do that I just ran into.
DECLARE @a TABLE
(
  id int
)
DECLARE @b TABLE
(
  id int,
  name nvarchar(10),
  fid int
)

insert into @a (id) values (1)
insert into @b (id, name, fid) values (1, 'Test', 1)

delete from @a where id in
(
	select [@a].id from @a
		inner join @b 
		on [@b].fid = [@a].id
)

select COUNT(*) from @a