/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 vote143 views1 answer
How to get n result in sql
SQL
3 votes150 views2 answers
Sql random integer
SQL
-1 vote160 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
1 vote141 views2 answers
Postgresql list columns
SQL
0 vote154 views3 answers
Database restoring error
SQL
19 votes167 views5 answers
Display table in sql
SQL
15 votes185 views3 answers
Create table with primary key auto increment in sql
SQL
0 vote138 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
3 votes101 views4 answers
Show columns from table
SQL
3 votes175 views2 answers
How to modify rows in SQL Server
SQL