By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,906 Members | 1,771 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,906 IT Pros & Developers. It's quick & easy.

how to store many files in one database field

100+
P: 102
how to store many files in one database fields?? i manage to store one file into database field.. but fail to store many files.....

how should i do that>> one database field for many files name.. is this way correct???

or each field for one filename?? 10 fields for 10 files??
Jul 21 '07 #1
Share this Question
Share on Google+
4 Replies


P: 26
Sounds like you should create association table
Jul 24 '07 #2

100+
P: 102
is this how all people do for this problem?? how do u all insert multiple files into database>>> ???
Jul 24 '07 #3

100+
P: 102
is this how all people do for this problem?? how do u all insert multiple files into database>>> ???
waht is association tables.
Jul 24 '07 #4

P: 26
Well I don't have your schema but I would keep your existing Table A and create another table call it documents that has a foreign key to Table A's ID column.

For example,
Table A
ID = 1

Table B (2 columns (or 3 if you don't want composite key)
Columns
Filename
Table A ID

Then you can have a single record in Table A but many filenames in Table B.
Jul 24 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.