/SQL/How to define a save method in ruby for sql databases

How to define a save method in ruby for sql databases

def save
    sql = <<-SQL
      INSERT INTO songs (name, album) 
      VALUES (?, ?)
    SQL
 
    DB[:conn].execute(sql, self.name, self.album)
 
    @id = DB[:conn].execute("SELECT last_insert_rowid() FROM songs")[0][0]
 
  end

Similar codes

3 votes197 views1 answer
Force using index plsql
SQL
0 vote190 views1 answer
Sql random decimal
SQL
0 vote221 views1 answer
Oracle insert single quote in string
SQL
0 vote215 views1 answer
Hoq to import database source
SQL
0 vote212 views1 answer
Search starting with mysql
SQL
0 vote198 views1 answer
If null don't update
SQL
0 vote204 views1 answer
Sql_inner_join
SQL
0 vote193 views2 answers
Sql searching via key word
SQL
1 vote205 views1 answer
Hexadec to sql REDSHIFT
SQL
1 vote205 views1 answer
SQL date part only of datetime
SQL