/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

16 votes368 views2 answers
Sql exists
SQL
1 vote383 views1 answer
Round function in sql oracle
SQL
4 votes355 views2 answers
Postgresql reset sequence
SQL
7 votes435 views2 answers
3rd height salary sql
SQL
0 vote363 views4 answers
Mysql count table rows
SQL
0 vote417 views1 answer
Copy row from db to db mysql
SQL
1 vote323 views1 answer
Oracle boolean to varchar
SQL
0 vote397 views1 answer
Sql select column name like from multiple tables
SQL
0 vote351 views2 answers
Postgresql get long running queries
SQL
12 votes347 views1 answer
Env var for setting password for root user mysql docker hub
SQL