469,317 Members | 1,986 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,317 developers. It's quick & easy.

how to store many files in one database field

102 100+
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
4 1726
Sounds like you should create association table
Jul 24 '07 #2
lyealain
102 100+
is this how all people do for this problem?? how do u all insert multiple files into database>>> ???
Jul 24 '07 #3
lyealain
102 100+
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
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.

Similar topics

3 posts views Thread by Steve | last post: by
2 posts views Thread by Tim Zych | last post: by
2 posts views Thread by wschanks | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.