/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

22 votes178 views4 answers
Mysql reset auto increment id
SQL
11 votes266 views1 answer
Oracle insert from select
SQL
0 vote181 views1 answer
Sql shell psql cannot enter password
SQL
0 vote204 views1 answer
How to add unique key constraint in mysql
SQL
1 vote223 views1 answer
Mysql tables max count
SQL
2 votes199 views1 answer
Oracle sql merge
SQL
1 vote186 views1 answer
How to group by month using sql server
SQL
0 vote180 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote183 views1 answer
Find number of entries sql
SQL
0 vote191 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL