/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

5 votes127 views2 answers
Postgre insert select
SQL
0 vote126 views1 answer
What are the aggregate function in sql
SQL
1 vote135 views1 answer
Get table which have specific columns in mysql
SQL
0 vote158 views1 answer
Add computed column to table sql server
SQL
37 votes173 views6 answers
Mysql update
SQL
3 votes146 views2 answers
Postgresql select all column names
SQL
0 vote138 views2 answers
T sql null or empty string
SQL
0 vote123 views1 answer
Python mysql query where
SQL
0 vote133 views1 answer
Top 3 salary in sql
SQL
1 vote129 views1 answer
Find a column in all tables postgres
SQL