Update

 ('ram', 'male',401)

('sam', 'male',458)

('priya', 'female', 456)

('ram', 'male',401)

('sam', 'male',456)

('priya', 'female',500)

Update Successfully

(ram', 'male',401)

('sam', 'mark',458)

('priya', 'male',500)

('sam', 'male',458)

('Priya', 'female',500)

Delete Sucessfully

(sam', 'male',458)

('priya', 'female',500)

Drop Successfully

Popular posts from this blog

Types of arguments in python

1. Default arguments 2. Keyword arguments 3. Positional arguments 4. Arbitrary positional arguments 5. Arbitrary keyword arguments Default arguments : Default arguments are values that are provided while  defining functions. The assignment operator = is used to assign a default  value to the argument. Ex: def add(a,b=5,c=10):  return (a+b+c) x=add(14) print(x) Keyword Arguments : Functions can also be called using keyword arguments of the form kwarg=value.During a function call, values passed through arguments don’t need to be in the order of parameters in the function definitions. Ex : def add(a,b,c): return (a+b+c) m=add(b=10,c=15,a=20) print(m) Positional Arguments : arguments are passed in order one after the other, those  arguments are called the "Positional arguments." Eg : def add(a,b,c):  return (a+b+c) print (add(10,20,30)) Arbitrary Positional Argument : For arbitrary positional argument, an asterisk (*) is placed  before a parameter in function d...
Read more

Select

 Select all records from table ('jebaroshan', '24UCS023',89,67) ('ram', '24UCS034',90,87) ('Sam', '24UCS045', 85, 79) Select particular columns ('jebaroshan', 89) ('ram',90) ('Sam',85) Select particular rows ('ram', '24UCS034,90, 87) Select particular rows and columns ('ram', '24UCS034') ('Sam', '24UCS045')
Read more