<commit_before>#Program to perform update operation.
require 'mysql'

begin

db1=Mysql.new('localhost','root','root','college')
=begin
db1.query("create table test_student(sname varchar(25),age integer,grade char(1))")
db1.query("insert into test_student values('Ganga',23,'B')")
db1.query("insert into test_student values('Raman',22,'A')")
db1.query("insert into test_student values('Nataraj',21,'C')")
db1.query("insert into test_student values('<NAME>',22,'C')")
db1.query("insert into test_student values('Raghavan',22,'B')")
db1.query("update test_student set grade='B' where sname like 'Ram%'")
=end
db1.query("delete from test_student where sname like 'uma'")

end<commit_msg>Code to dalete record fetched from user@runtime in table<commit_after>#Program to perform update operation.
require 'mysql'

begin

db1=Mysql.new('localhost','root','root','college')
=begin
db1.query("create table test_student(sname varchar(25),age integer,grade char(1))")
db1.query("insert into test_student values('Ganga',23,'B')")
db1.query("insert into test_student values('Raman',22,'A')")
db1.query("insert into test_student values('Nataraj',21,'C')")
db1.query("insert into test_student values('<NAME>',22,'C')")
db1.query("insert into test_student values('Raghavan',22,'B')")
db1.query("update test_student set grade='B' where sname like 'Ram%'")
=end
puts "Input student data to be deleted : "
print "Name  : "
name=gets
db1.query("delete from test_student where sname like '#{name}'")
print "#{name} record deleted."

end
{'fraction_non_alphanumeric': 0.17227722772277226, 'fraction_numerical': 0.029042904290429043, 'mean_word_length': 8.534591194968554, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6596269', 'n_tokens_mistral': 520, 'n_tokens_neox': 505, 'n_words': 127}