<p>I have a trigger in which I want to have a variable that holds an INT I get from a <code>SELECT</code>, so I can use it in two IF statements instead of calling the <code>SELECT</code> twice. How do you declare/use variables in MySQL triggers?</p>

```
```
`CREATE TRIGGER `category_before_ins_tr` BEFORE INSERT ON `category`
  FOR EACH ROW
BEGIN
    **SET @tableId= (SELECT id FROM dummy LIMIT 1);**

END;`;
```
```