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

How to define a save method in ruby for sqlite3 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

0 vote194 views1 answer
Pass array parameter to stored procedure c#
SQL
-1 vote166 views1 answer
Sql getdate date only
SQL
3 votes198 views1 answer
Oracle function return
SQL
0 vote188 views1 answer
Excel export from sql using python
SQL
4 votes189 views2 answers
Sql offset
SQL
4 votes157 views1 answer
Sql list users and roles
SQL
2 votes176 views1 answer
Postgresql change value in column
SQL
0 vote179 views1 answer
Can we rollback deleted data in sql
SQL
0 vote213 views1 answer
Mysql bind-address default value
SQL
0 vote186 views1 answer
Sql find table by name
SQL