/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

0 vote238 views1 answer
Gcloud sql instance list
SQL
5 votes225 views1 answer
Oracle get ddl
SQL
6 votes204 views2 answers
Drop foreign key
SQL
0 vote203 views1 answer
Oracle table free space
SQL
0 vote229 views1 answer
Where date in datetime mysql
SQL
0 vote193 views2 answers
How to combine diff colmun value using group by postgres
SQL
1 vote187 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote214 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
1 vote223 views1 answer
Increase date by one day in sql oracle
SQL
0 vote217 views1 answer
Oracle grant create job
SQL