MySQL optimised code for 2 tables?
Posted
by
David19801
on Stack Overflow
See other posts from Stack Overflow
or by David19801
Published on 2010-12-25T09:36:28Z
Indexed on
2010/12/25
9:54 UTC
Read the original article
Hit count: 225
Hi,
I have 2 tables,
Table1: id,int1,int2,int3,int4,int5
Table2: integers (autoincrement),blobdata
The query I want to use is given the id I want to get the blobdata from table2 associated with the 5 integers in table1. I've only ever used one table in mysql so have no idea how to do this properly.
Is it possible?
EDIT: id is username, integers in table2 is just integers. but have not built the tables yet, so can change if need to.
© Stack Overflow or respective owner