/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

2 votes340 views2 answers
Mysql does sentence contain word
SQL
1 vote281 views4 answers
Fatal database postgres does not exist
SQL
0 vote324 views1 answer
Mssql dockere
SQL
11 votes300 views2 answers
Set default column value sql
SQL
3 votes302 views2 answers
Truncate all tables
SQL
0 vote310 views1 answer
Mysql root localhost run
SQL
-2 votes297 views3 answers
Oracle tablespace usage
SQL
-1 vote319 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote324 views1 answer
Postgres get database encoding
SQL
1 vote323 views1 answer
Psql connect
SQL