[Solved] How to solve MySQL error code: 1062 duplicate entry?

/ by 

Error Message: Error Code: 1062. Duplicate entry ‘%s’ for key %d Example: Error Code: 1062. Duplicate entry ‘1’ for key ‘PRIMARY’ Possible Reason: Case 1: Duplicate value. The data you are trying to insert is already present in the column primary key. The primary key column...

How to write SQL query?

/ by 

We have discussed about the conceptual data model, logical data model, normalization and denormalization techniques and we discussed about installing and running up with MySQL community server.  What will be next? Once we build the data model and decided the database server, the next process...

How to install MySQL server on windows?

/ by 

Last week I got an assignment where I need to install MySQL server on client’s machine, after checking the system requirements, I came to know that, the machine contains the 64 bit windows operating system. So I thought to download MySQL community server for windows 64 bit operating system, but I found...

Database denormalization techniques

/ by 

We have seen about the normalization and different levels of normalization in previous post. A normalized database design will store the information in more number smaller and separate tables. When you need to retrieve particular information from a normalized database you need to perform join operation,...
Subscribe to: Posts (Atom)