Interested to Buy Any Domain ? << Click Here >> for more details...
What is a pseudo key? What is its use???
- 2 Answers
- 19033 Views
- Mphasis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / tdguy
If a table in a database either has no natural key or the
natural key is so long that using it as the key would be
inefficient then we need to consider using a pseudokey
instead. Pseudokeys are usually given the same name as the
table they belong to with _id added to the end of the name.
They usually are defined to contain a number and use
autoincrement in mySQL or the equivalent in other versions
of SQL to dynamically allocate a value when new rows are
created.
source: http://www.felgall.com/mysql04.htm
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / guest
it is used in locks the rowhash
best to tell EXPLAIN in this explanation we locks pseudo key
then it start
| Is This Answer Correct ? | 0 Yes | 10 No |
What is SQL Assistence?please eample
How to cast date "2015-03-03-012204-000000" to timestamp
What are some commonly used bteq scripts?
What is teradata? Also, list out some of the primary characteristics of teradata.
What do you mean by caching in teradata?
What is the use of fallback?
Highlight the need for Performance Tuning.
what are the default access rights in the teradata?
if a error occured in FASTLOAD is the fastload job stops?
Can you load multiple data files for same target table using fastload?
What interface is used to connect to windows based applications?
what is the difference between filter and router transmissions
Teradata 
