1 / 46

select * from reg

select * from reg. create table reg. (. login varchar(30)not null,. cpassword varchar(30)not null,. email varchar(30)not null,. taste varchar(30)not null,. address varchar(30)not null,. phone varchar(30)null,. ). alter table reg add constraint pklogin primary key clustered (login).

chester-ashley
Download Presentation

select * from reg

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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'

More Related