/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

3 votes301 views1 answer
Delete all content in table mysql
SQL
0 vote324 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote333 views1 answer
How to generate ids in sql
SQL
4 votes314 views1 answer
Sql quote in string
SQL
2 votes343 views2 answers
How to add not null constraint in sql
SQL
13 votes338 views3 answers
Insert mysql ifile nto database
SQL
0 vote313 views1 answer
MySQL - How to find word with the most similar beginning
SQL
0 vote329 views1 answer
Enable sql server full text indexing
SQL
2 votes320 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote309 views1 answer
Change schema of all tables postgres
SQL