Click here to Skip to main content
15,558,279 members
Home / Discussions / Database
   

Database

 
GeneralRe: single DataSet having multiple DataTables from multiple databases Pin
Richard Deeming16-Jun-17 3:22
mveRichard Deeming16-Jun-17 3:22 
AnswerRe: single DataSet having multiple DataTables from multiple databases Pin
Mycroft Holmes15-Jun-17 14:16
professionalMycroft Holmes15-Jun-17 14:16 
GeneralRe: single DataSet having multiple DataTables from multiple databases Pin
Eddy Vluggen16-Jun-17 4:18
professionalEddy Vluggen16-Jun-17 4:18 
QuestionError in SSIS Connection says (Test connection failed because of an error in initializing provider. ORA-12541: TNS:no listener) Pin
indian1437-Jun-17 14:12
indian1437-Jun-17 14:12 
AnswerRe: Error in SSIS Connection says (Test connection failed because of an error in initializing provider. ORA-12541: TNS:no listener) Pin
mike1402125-Jun-17 22:53
mike1402125-Jun-17 22:53 
QuestionI need advice on storing application level encrypted data. Pin
Gilbert Consellado5-Jun-17 19:26
professionalGilbert Consellado5-Jun-17 19:26 
SuggestionRe: I need advice on storing application level encrypted data. Pin
Kornfeld Eliyahu Peter5-Jun-17 21:50
professionalKornfeld Eliyahu Peter5-Jun-17 21:50 
QuestionHow do I write the insert sql statement for the following scenario ? Pin
karengsh3-Jun-17 23:30
karengsh3-Jun-17 23:30 
Hi expert,

Database : MySQL

I am trying to create 2 tables with a one-to-many relationship.
Table 1 - tutor
Table 2 - subject

In my table tutor, I have id as the Primary key and it is auto-incremental.

In my subject, I have id as the Primary key and it is auto-incremental, tutorNRIC as the foreign key and tutorNRIC in my tutor table as the reference key.

For my subject, there will be more than one entry in the column tutor_subject.

For example, a tutor will sign up and then all the subjects that she can teach will be entered into that column tutor_subjet.

I'd like to check if my insert sql is correct :

SQL
private final String INSERT_QRY1 = "INSERT INTO hi5project.subject tutor_subject, tutorNRIC VALUES ('?', '?') SET tutorNRIC = hi5project.tutor.tutorNRIC";


Thanks.
AnswerRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes4-Jun-17 14:49
professionalMycroft Holmes4-Jun-17 14:49 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh4-Jun-17 21:41
karengsh4-Jun-17 21:41 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes4-Jun-17 21:58
professionalMycroft Holmes4-Jun-17 21:58 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh4-Jun-17 23:12
karengsh4-Jun-17 23:12 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes5-Jun-17 13:05
professionalMycroft Holmes5-Jun-17 13:05 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh10-Jun-17 20:12
karengsh10-Jun-17 20:12 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes10-Jun-17 21:45
professionalMycroft Holmes10-Jun-17 21:45 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh11-Jun-17 18:38
karengsh11-Jun-17 18:38 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes12-Jun-17 0:39
professionalMycroft Holmes12-Jun-17 0:39 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh14-Jun-17 19:55
karengsh14-Jun-17 19:55 
Questionwhy we use datareader Pin
Mazahir Habib1-Jun-17 21:10
Mazahir Habib1-Jun-17 21:10 
AnswerRe: why we use datareader Pin
John C Rayan1-Jun-17 23:16
professionalJohn C Rayan1-Jun-17 23:16 
GeneralRe: why we use datareader Pin
Mycroft Holmes1-Jun-17 23:25
professionalMycroft Holmes1-Jun-17 23:25 
Questionattempt to load oracle client libraries threw badimageformatexception ssis Pin
indian1431-Jun-17 14:59
indian1431-Jun-17 14:59 
AnswerRe: attempt to load oracle client libraries threw badimageformatexception ssis Pin
Richard Deeming2-Jun-17 2:18
mveRichard Deeming2-Jun-17 2:18 
QuestionLoading Data on Demand Pin
Richard Andrew x6431-May-17 12:02
professionalRichard Andrew x6431-May-17 12:02 
AnswerRe: Loading Data on Demand Pin
Richard Deeming31-May-17 12:44
mveRichard Deeming31-May-17 12:44 

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.