Grant all privileges of database to a user
- Query
- grant all privileges on publisher.* to gaurav@localhost identified by 'sqlimplant'
- Here publisher is database name
- 'gaurav' is user name
- 'sqlimplant' is the password
Surrogate primary Keys or Pseudo Primary Keys
The value of primary keys which carry no business information are called as Surrogate primary keys or Pseudo primary keys. The primary keys which contain business information are called as natural primary keys for example isbn's of books.
Comments
Post a Comment