在sql中更新/插入记录的正确/最快方法是什么（Firebird / MySql）

I need some SQL to update a record in a database if it exists and insert it when it does not, looking around there looks to be several solutions for this, but I don't know what are the correct/ accepted ways to do this.I need some SQL to update a record in a databas