Download
select from reg n.
Skip this Video
Loading SlideShow in 5 Seconds..
select * from reg PowerPoint Presentation
Download Presentation
select * from reg

select * from reg

106 Views Download Presentation
Download Presentation

select * from reg

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. select * from reg

  2. create table reg

  3. (

  4. login varchar(30)not null,

  5. cpassword varchar(30)not null,

  6. email varchar(30)not null,

  7. taste varchar(30)not null,

  8. address varchar(30)not null,

  9. phone varchar(30)null,

  10. )

  11. alter table reg add constraint pklogin primary key clustered (login)

  12. insert into reg values('vidhyashank.m','sar','vidhyashankar.m@gmail.com','pop','20,radak street,ch-24','044-22334353')

  13. drop table reg

  14. select * from admin

  15. create table admin

  16. (

  17. login varchar(30)not null,

  18. cpassword varchar(30)not null,

  19. emp_id varchar(30)not null,

  20. )

  21. alter table admin add constraint plogin primary key clustered (login)

  22. insert into admin values('shankar.m','saras','001')

  23. drop table admin

  24. select * from songs

  25. create table songs

  26. (

  27. song_id varchar(30)not null,

  28. album varchar(30)not null,

  29. artist varchar(30)not null,

  30. type varchar(30)not null,

  31. votes varchar(30)not null

  32. )

  33. alter table songs add constraint pksong_id primary key clustered (song_id)

  34. insert into songs values('001','dhool','muniyamma','cinema','5')

  35. drop table songs

  36. create table message

  37. (

  38. type varchar(30)not null,

  39. messages varchar(1000)not null,

  40. )

  41. insert into message values('pop','hi folks a new pop album by Mike Jackson is d latest on the site')

  42. insert into message values('cinema','hi folks a new song by Mano is awaiting to b heared by u ')

  43. insert into message values('classical','hi folks a new carnatic album by Nithyashree Mahadevan is d latest on the site')

  44. select * from message

  45. drop table message

  46. update message set messages = 'hi' where type = 'pop'