Click here to Skip to main content
15,881,248 members
Home / Discussions / Database
   

Database

 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Richard Deeming5-Aug-16 1:53
mveRichard Deeming5-Aug-16 1:53 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Member 126624485-Aug-16 9:14
Member 126624485-Aug-16 9:14 
QuestionSearching for the right database Pin
Kogs-7927-Jul-16 3:04
Kogs-7927-Jul-16 3:04 
SuggestionRe: Searching for the right database Pin
Richard MacCutchan27-Jul-16 4:56
mveRichard MacCutchan27-Jul-16 4:56 
GeneralRe: Searching for the right database Pin
Kogs-7927-Jul-16 23:42
Kogs-7927-Jul-16 23:42 
QuestionRe: Searching for the right database Pin
User 1106097927-Jul-16 20:33
User 1106097927-Jul-16 20:33 
AnswerRe: Searching for the right database Pin
Kogs-7927-Jul-16 23:56
Kogs-7927-Jul-16 23:56 
AnswerRe: Searching for the right database Pin
Bernhard Hiller27-Jul-16 21:11
Bernhard Hiller27-Jul-16 21:11 
Some points to consider:
- are your keys case-sensitive? In MS SQL, string comparison is normally not case-sensitive, while with postgres or Oracle it is.
- what is the relation ship between the two tables? Do I understand you correctly that there are keys which exist in Table1 only, and other keys which exist in Table2 only?
- do you need some kind of reporting? I.e. how many different keys can be found for a value for keys exiting in both or only one table. Complex aggregation queries work fastest in MS SQL or Oracle, while mysql copes with simple aggregations only (but with two tables, that should still be ok).
- What would you do if a key to be added already exists? Update the record or throw an exception?
GeneralRe: Searching for the right database Pin
Kogs-7927-Jul-16 23:37
Kogs-7927-Jul-16 23:37 
GeneralRe: Searching for the right database Pin
Jörgen Andersson31-Jul-16 5:27
professionalJörgen Andersson31-Jul-16 5:27 
Questioncannot use "dynamic" Connection String with Excel? Pin
Vinny Ardhya20-Jul-16 22:29
Vinny Ardhya20-Jul-16 22:29 
AnswerRe: cannot use "dynamic" Connection String with Excel? Pin
Victor Nijegorodov23-Jul-16 9:27
Victor Nijegorodov23-Jul-16 9:27 
GeneralRe: cannot use "dynamic" Connection String with Excel? Pin
Vinny Ardhya24-Jul-16 15:58
Vinny Ardhya24-Jul-16 15:58 
AnswerRe: cannot use "dynamic" Connection String with Excel? Pin
Peter_in_278024-Jul-16 16:36
professionalPeter_in_278024-Jul-16 16:36 
GeneralRe: cannot use "dynamic" Connection String with Excel? Pin
Vinny Ardhya24-Jul-16 17:15
Vinny Ardhya24-Jul-16 17:15 
GeneralRe: cannot use "dynamic" Connection String with Excel? Pin
Richard MacCutchan24-Jul-16 20:54
mveRichard MacCutchan24-Jul-16 20:54 
QuestionEncrypt email address to 6-8 digit alphanumeric Pin
sumit703418-Jul-16 22:55
sumit703418-Jul-16 22:55 
AnswerRe: Encrypt email address to 6-8 digit alphanumeric Pin
Richard MacCutchan19-Jul-16 3:14
mveRichard MacCutchan19-Jul-16 3:14 
Generalmovement of foreign key Pin
Member 1141876917-Jul-16 12:56
Member 1141876917-Jul-16 12:56 
GeneralRe: movement of foreign key Pin
User 1106097917-Jul-16 23:10
User 1106097917-Jul-16 23:10 
QuestionRestore CDC Data Pin
maryam.saboor16-Jul-16 19:39
professionalmaryam.saboor16-Jul-16 19:39 
AnswerRe: Restore CDC Data Pin
maryam.saboor18-Jul-16 18:54
professionalmaryam.saboor18-Jul-16 18:54 
QuestionMySQL - Update a table from same table using SELECT Pin
Jassim Rahma16-Jul-16 11:54
Jassim Rahma16-Jul-16 11:54 
AnswerRe: MySQL - Update a table from same table using SELECT Pin
Mycroft Holmes16-Jul-16 13:38
professionalMycroft Holmes16-Jul-16 13:38 
AnswerRe: MySQL - Update a table from same table using SELECT Pin
User 1106097917-Jul-16 1:37
User 1106097917-Jul-16 1:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.